April 22, 2004 at 9:34 am
I want to do some Disaster recovery plan in case production server crashes completeley (or similar situation scenario). After rebuilding the server, and installing the SQL server (2000, Standard) with the right version and service packs, I will restore the users DB from the tape. ( Backup of the databases, User and System are already on tape). How can we restore user logins and the rights back in the system? What else needs to be done to make sure the Database is in working condition as before.
Thanks in advance for the help.
Irshad.
April 22, 2004 at 9:46 am
Restore master will gives you all logins, restore users database will give you all database, users and rights, restore msdb will give you all your backup tasks and other stuff. You might have to do sp_changedbowner to change dbo it's original owner but that's all there is to it.
mom
April 22, 2004 at 9:53 am
Thanks a lot. I will try that. The only concern I had about restoring Master DB.
Irshad.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply