September 6, 2011 at 8:59 am
Hello all. I do sys admin work for a small network but I rarely do anything with sqlserver and don't know a lot about it. I have sqlserver installed on the C: drive of a Windows 2003 server, and the C: drive is running out of space. Sqlserver has two databases on it and the data for both is on the D: drive which has plenty of space, however, the Sqlserver directory under Program Files on the C: drive is almost 2 gig. I was wondering if this can be safely moved to the D: drive without having to completely re-install ?
September 6, 2011 at 9:19 am
It's never a good idea with today's Registry intensive applications to move an install from one drive to another. That being said, what you may want to consider is seeing if you can somehow uninstall anything unneeded on the C:DRIVE before you move anything for SQL.
2 other questions:
1. Are you C: and D: drives just logical partitions of the same disk, or are they independent drives on independent channel controllers, and...
2. What else is running on this server that has your Program Files directory sitting at 2gb?
September 6, 2011 at 9:22 am
You might also check if you have traces or logging going on in the sql folders. Those can eat up a lot of room in no time flat.
September 6, 2011 at 9:56 am
you probably have your SQL system databases installed on the C drive and these are the likely culprits for using up space. these can be moved. I would avoid moving the master database and model database will probably be very small but moving tempdb and/or msdb should give you the space back.
check where your backups are going to as well. (.bak files)
Errorlogs can be moved, but moving any binaries can only be done with a reinstall.
see http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.100).aspx
---------------------------------------------------------------------
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply