Q

Problems running SQL Server 2000 RTM without service pack

Business Intelligence expert Eric Brown helps troubleshoot database growth problems.

I have a client running Microsoft SQL Server 2000 RTM. There is no service pack.

My operating system is Windows 2000 Server;
storage is an old 35 GB hard drive;
partitioned C: at 4 GB (yes, 4) with second partition about 30 GB as data area E drive;
tempdbs are on C: and get up to 2 GB causing problems. C: part is full.

I might suggest moving everything out and starting again fresh if possible. Use multiple drives and put the mdf file (the data files) in a big enough disk to last a while, so 40 GB. Use another disk for the LDF files. The LDF file can be set to autogrowth -- that's a good thing -- just make sure to plan enough room for growth. This can all be done in Enterprise Manager.

And simply update the machine completely to the new service packs -- this is a no brainer.

View questions and answers from all SQL Server experts here.

This was first published in March 2006

Dig deeper on Microsoft SQL Server 2000

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close