New SQL 2000 install

[swoodring]

I am installing SQL 2000 on a brand new server. Once installed I will need to restore my db's from our current SQL 7.0 server. I know I can restore the user db's. I've read that you can not restore the MSDB and master db's. So What steps would I take to make sure I get all the info in these db's? I found an article on how to transfer logins and passwords, so that should get me my logins. I'm guessing I'll have to script up my packages /jobs somehow. How do I go about doing this? And what else am I missing that I will need to do in order for my master/msdb to contain everything that it contained on the SQl 7.0 server?


Stacy

 

[tlbroadbent]

For package transfers check the following:

http://www.sqldts.com/main.asp?nav=1,6,204,0

You can script the jobs and create them on the new server. You can also create a transfer jobs task in SQL 2000 DTS. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.