moving system database
-
I have to do moving database (master) i have to move it logical and physical file from one drive to another drive
I have to move tempdb, model , etc
please help
thank you
-
looping
Thanks
-
-
Ignacio A. Salom Rangel (8/11/2011)
You can use the steps in this link. Good luck!Big daddy. you are correct. Some forums suggested to use detach attach method for system databases using some trace flag. But is is safest to use alter file statement, change the location, stop services, copy files and then start again.
-
chandan_jha18 (8/11/2011)
Ignacio A. Salom Rangel (8/11/2011)
You can use the steps in this link. Good luck!Big daddy. you are correct. Some forums suggested to use detach attach method for system databases using some trace flag. But is is safest to use alter file statement, change the location, stop services, copy files and then start again.
🙂
-
For SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx
For SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.100).aspx
For SQL Server 2008 R2
http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.105).aspx
Thanks
Chris
------------------------
I am the master of my fate:
I am the captain of my soul.
------------------------
Blog: http://sqlserver365.blogspot.co.uk/
Twitter: @ckwmcgowan
------------------------
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply