Reloading SQL Server 7

[pio]

This weekend my company is moving our web server over to a web hosting company this weekend. We are also going to wipe out the current NT 4 OS and start fresh with a new 2000 Server install. We currently have SQL 7 installed. My question to you is: "When 2000 server is installed and I get the SQL Server 7 installed, how can I get the databases back onto the server?" I've never done this before. Any help would be greatly appreciated.

Thanks in advance...

 

[tlbroadbent]

You can attach the SQL user databases to SQL 2000 or you can restore SQL 7 backups to SQL 2000. However, you cannot restore system databases such as master and msdb. You should script DTS Packages stoed in msdb, job (msdb), logins (master) and any user created stored procedures in SQL 7 and run the scripts in the new server after installing SQL 2000 and attaching user databases. 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 in the SQL Server forum. Many of the ideas apply to all forums.

 

[goly]

HI
I use import for D.B. copying from one server to another.
works fine for us.

 

[LucieLastic]

Could one not use Backup Database and Restore database on the new server ?

lou

 

[goly]

HI Weez
I was using backup and restore but then I had to choose selectively the tables to copy from one server to another so I started using the import option.
would some one please refer me to the differences between attaching-importing-backuping database? when each metode is prefarable?