Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sailtodo
Starting Member
2 Posts |
 Posted - 2008-04-04 : 10:00:36
|
| I have a SQL 2005 server I am working on for a client and the issue is this. The original install was put on the servers c:\ partition. When they ran out of space they moved all of the databases to a different drive. They still run into problems when they run maintenance plans. Half of them fail as drive c:\ runs out of space.Is there a temp directory or file that needs to be moved and if so how do I do this? Do SQL system databases grow when a maintenance plan is run? Do the system databases need to be moved as well? I assume that these changes will require down time but I would like to avoid that if possible.I am new to SQL and I have looked everywhere but have found no solutions. I would think there must be a temp directory where data is stored during the job.Any help would be appreciated. Thanks.Steve |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 10:14:55
|
| Never install SQL Server on C: Drive. (C:) Drive is specifically for OS.You have to move System databases (TEMPDB and MSDB) to other location . Check 'Moving system databases in SQL server 2005' in BOL. I tried that and it worked but you need downtime for that. |
 |
|
|
sailtodo
Starting Member
2 Posts |
Posted - 2008-04-04 : 14:10:01
|
| Thanks for the help. |
|
|
|
|
|
|
SQL 2005 drive space issues