August 3, 2010 at 3:30 am
I have a small server that I've installed SQL2008 on, and cannot run SP1 as there is not enough space on C:
I created users for the SQL Server, SQL Agent and Reporting Services service accounts to run under, and Windows has created entries for them all in C:\Documents and Settings. For some reason the Default user has a large profile so each of these folders are 85MB in size
Are these in any way necessary for the running of SQL Server? Can I delete them to free up 250MB of space so I can (hopefully) run the SP1?
Thank you.
August 3, 2010 at 4:31 am
You may safely move that folder to some other location. In SQL Server 2000, there was a dependency on this folder, since it used to store the Outlook configuration used in SQLMail.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 4:44 am
August 3, 2010 at 5:21 am
Things I usually check on a client site are:
Tempdb and other system databases on the C: drive - these can (and should) be moved away from the system partition
The Windows Pagefile is on C: by default.
Undersized system drives used to be the bane of my life at a previous company - everyone underestimates how big modern OS's and all their service packs/hot fixes get 😛
August 3, 2010 at 5:27 am
HowardW (8/3/2010)
Things I usually check on a client site are:Tempdb and other system databases on the C: drive - these can (and should) be moved away from the system partition
All good with those
The Windows Pagefile is on C: by default.
Yep - that's the next thing we're trying. That's about 1.5GB, if it still runs out of space after that I will explode!
Undersized system drives used to be the bane of my life at a previous company - everyone underestimates how big modern OS's and all their service packs/hot fixes get 😛
Oh, I hear you. Our standard issue C drives seem to be 8GB.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply