we are trying to simulate a disater recovery of our SQL2000 and SQL2005 development servers. Which is the order in which we should restore the DBs. I am talking specifically of MSDB, master and user DBs; should we restore user DBs before master and MSDB?
Thanks,
CarlosGenerally, you restore master first, then model(if you made any changes to it), and msdb. After that, all the user databases should be restored. THis goes for SQL 2000 and SQL 2005.|||Generally I have a standby box|||lucky little %^*)|||lucky little %^*)
He didn't say WHAT kind of box. It's actually a box of 64 crayola crayons.
Regards,
hmscott|||i thought the first thing to do was to start blaming other people. maybe followed by some frantic yelling all around the office.
maybe Brett has a squeezebox. But wait, if he has a squeezebox who doesn't sleep at night? I am confused. Back to writing code.
没有评论:
发表评论