August 5, 2002 at 10:00 am
Hello everyone, I need your opinion on this:
One of the hard drives on one of my servers crashed. I am restoring the databases that reside on that server to other servers so that the users can go on using the databases until I get new hard drive and install it. Anyways, when I recover the databases back to the original server, would I need to also recover the master, msdb databases? BTW, I will be reinstalling a fresh copy of SQL 2000 on that server because that server is still SQL 7. Thanks all.
August 5, 2002 at 10:13 am
If you want logins you will, but I'm not sure that SQL 2000 will work there. If you're moving database, save your login scripts and then just restore/attach them back on the original server.
and get RAID.
Steve Jones
August 5, 2002 at 10:28 am
Steve,
How do I save my login scripts? We have RAID in place.
August 5, 2002 at 10:30 am
The scripts you use to recreate logins on other boxes. I'd script it rather than using EM.
If you don't have these, and you can get at the old master, you can use DTS to export them.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply