How to Deattach and Attach System Databases
-
Dear All Gurus
This is dharmendra again back with some of the questions. I hav got a situation that how to Deattach and attache the system database. As i am in a Disaster of Uninstalling the SQL SERVER. Pls help me out.
Any help would be greatly appreciated.
Thanx
Dharmendra Mudaliar
Thanks & Regards
Dharmendra S Mudaliar
( OEM India RSA )
Hello - +91 40 66934555 x 34555
Mobile - 9885408049 | IM - v-dharmu@microsoft.com -
I don't know if you can detach system databases, but you can try this:
- 1. Shut down the SQL services
- 2. Copy the system ldf and mdf files
- 3. Install SQL Server to same version and service pack level
- 4. Stop SQL server
- 5. Rename new system databases
- 6. Put original system ldf and mdf in place of new files
- 7. Start up SQL.
I have used this technique with sucess during several server rebuilds. It might work depending on what your disaster is.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor -
See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanx Kathi & Frank
But my questions was i dont want to reinstall the SQL SERVER i only wanted my SQL SERVER Files to place at different drives and can i attached the System Database from another location.
thanx in advance
Regds
Dharmendra
Thanks & Regards
Dharmendra S Mudaliar
( OEM India RSA )
Hello - +91 40 66934555 x 34555
Mobile - 9885408049 | IM - v-dharmu@microsoft.com -
Did you read the link I've posted?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply