November 16, 2008 at 3:24 pm
Hi,
could you plz explain me the procedure to restore the system databases,if it is deleted accedentally?
November 16, 2008 at 3:54 pm
I'd start with reading Books Online about restoring the system databases. This is a good place to get basic information. From there, you can ask much more specific questions here where things don't make much sense.
November 17, 2008 at 3:44 am
If you would like to move sys DB from one server to another you can think about attach and detach option too. 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 17, 2008 at 3:29 pm
I hope you have a backup of Master and the other databases. If you can't restore master, you will need the installation media and run rebuildm.exe to restore the master database and then attach the other databases. BTW you can't attach or detach Master. Take your time to read BOL and rememeber what Server Collation and Sort order you originally installed your SQL Server with as getting this wrong can cause some 'weirdness'.
Have fun.
CodeOn
😛
November 17, 2008 at 4:06 pm
Hi all,
I thought rebuildm.exe was retired in 2005? When I ran through my backup/recovery testing I did the following:
1) Stop all the SQL services
2) put SQL in single user mode
3) use the setup.exe found on the SQL 2005 installation media
4) Rebuilt the master db using “start /wait setup.exe /qn INSTANCENAME= ” command
5) restart the SQL server services
6) restored mater db from my latest backup
Worked like a charm! :hehe:
Isabelle
Thanks!
Bea Isabelle
November 17, 2008 at 5:36 pm
Opps :blush: Wrong version.
Thanks for that.
CodeOn
😛
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply