sql 2000 install - new server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sql 2000 install - new server

Author

Topic

swoodring
Starting Member

5 Posts

Posted - 2002-07-01 : 11:54:30

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?

Also should I make the server name the same as the server name on the current box or do I have to make it another name? I'm talking about under the SQL server group.

Also I would like to keep the 7.0 version up for a bit and just make sure the 2000 side is working the way I want to . Our db are datawarehouse db that we use with another software package. So I will need to make changes there before I can totally turn it over to use the SQL 2000 db's One I've done this then I'll be ready for the switch. I will then restore the SQL 7.0 db again on the sql 2000 server and should be ready to go at that time.

What else am I missing. Any tips/precautions?

monkeybite
Posting Yak Master

152 Posts

Posted - 2002-07-01 : 12:02:17

This article will probably help to answer many of your questions:
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546&SD=MSKB[/url]