November 12, 2008 at 11:57 am
All my system db's are on a drive A(less space) where OS is loaded and the user db's are on differnt drive B(more space).
Now I want to move my system db to drive B or atleast tempdb so that i dont run into problems in future.
what is the best approch to do, is it mandatory that we need downtime?
November 12, 2008 at 12:07 pm
Yes, you will have downtime while you move your system databases to another drive. You can read one of the following articles on how to accomplish this task:
How to move SQL Server databases to a new location by using Detach ...
http://support.microsoft.com/kb/224071
Moving the SQL 2005 System Databases - SQL Server Central
http://www.sqlservercentral.com/articles/Administration/2605/
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 12, 2008 at 12:46 pm
It's simple, as Jonathan mentioned, but for sure there is downtime.
Not a lot, but enough to stop/restart SQL Server.
November 12, 2008 at 12:47 pm
Also, if you want more tempdb space, move it first, restart, then alter it for more space. Don't do both at once.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply