Master backup 1

[SQLScholar]

Hey all,

I am trying to find the easiest way that when a DB dies - i can get the server back up again. Both servers have the same software (i.e. SQL 2005, same version).

So - we have backups of all the databases (user and system). So questions

1) If i restore all the databases on the server, will everything just work identically to it did before? Does this include logins?

2) If i restore all system tables, but only one user DB - will that cause a problem with the system tables?

3) Is there any way to get round the above?

Basically - i want to find an easy way to get the database back - but with the logins working.

Many thanks

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mutley1]

You should restore the master (check BOL or MS for information) as that will hold all the information regarding logins and databases, then msdb (so you can backup jobs and DB's etc. when back up and running), then user databases. Plenty of documentation out there, but if the server dies, then it would be that order for the best recover. Rule 1 of total failure would be RESTORE master FIRST - shut down all SQL services and start it in single user mode (see documentation) then restore.

http://technet.microsoft.com/en-us/library/ms190679(SQL.90).aspx

Rgds,

M.

 

[mutley1]

Sorry, let me correct myself, rule 1 (AFTER checking all hardware / software etc. is running correctly!) would be to restore the master etc. etc.

 

[SQLScholar]

Mutley,

I thought that was the case.

Would it be a problem if i only restored some of the user databases? Would this cause an issue, as i would assume that the master\msdb would contain info on databases that wouldnt exist?

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mutley1]

You should resore the master, then you can restore whatever user ones you like - if you don't restore the other ones they will just sit there showing as suspect.