Migrating SQL 7 Database to another SQL 7 database

[cceng]

We want to move our SQL server database to a temp system while we rebuild the original. After we rebuild the original we will move the databases back.

Any good suggestion on doing this? Best option for success?

Thanks!

 

[redlam]

It may sound hokie but I've always created a backup of the database and restored it on the new server (then reverse the process when you're done). You will have to resolve your users on the new server (and possibly adjust file locations) but other than that - its a fairly easy process. Check out sp_resolve_logins in books online.

 

[redlam]

You could also check out sp_detach_db and sp_attach_db in books online. These system stored procedures detach your data and log files so that you can reattach them to a new server. I think this would work also - and could be even easier...

 

[cceng]

Thanks!

One last question, Books Online? Do you mean Microsofts?

 

[redlam]

Hi there.
Sorry, I should have clarified that. I'm pasting a quote from a previous thread from tlbroadbent that spells it out quite nicely. Hope this helps.

When we refer to SQL Books Online (BOL), we mean the electronic books that came with SQL Server. They can be loaded onto your harddrive as part of the SQL Server or client tools setup.

If you can't find them, SQL 7.0 BOL can be downloaded from Microsoft web site at

http://www.microsoft.com/sql/productinfo/70books.htm.

You can view SQL 2000 BOL at

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/portal_7ap1.htm.