SQL Server Performance Forum – Threads Archive
Shfiting of SQL default databaseOn our SQL Server we have 3 different HDD. HDD 1 is having OS. HDD 2 is having all the SQL by default databases i.e. Master, Model, Msdb, Tempdb, Pubs & Northwind.
HDD 3 is having application databases, which are in use. Because of HDD 2 problem we shift our application db to HDD 3. The capacity of HDD 3 is more and it#%92s new. My question is how should be my approach to shift all SQL default databases from HDD 2 to HDD 3?
Is there any risk involved in it?
How should I handle those risks?
I would recommend you to read carefully below given links, further if you have any doubts feel free to ask: – http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 http://www.sqlservercentral.com/columnists/chedgate/movingsystemdatabasesachecklist.asp http://www.databasejournal.com/features/mssql/article.php/3379901
Database Administration job is full of risk all the time.. Knowledge and carefully planned activities minimized all risk involved in activities.
Deepak Kumar –An eye for an eye and everyone shall be blind