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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-02 : 08:06:37
|
| Nat writes "We have a SQL 7 database no longer in production. We are ditching the server with SQL 7 application on it, but For legal reasons we need to save the db's from it for awhile. We have a SQL 2000 *in production*, however on another box and if in the future we need to retrieve data from the old SQL 7 db's how do we archive it to storage so that we can be assured of importing into the SQL 2000 server in the future and extract data if needed? What additional db's (if any, Master, for instance) do I need to save, as well? All steps would be appreciated.Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-02 : 08:09:20
|
| Make a full backup of your SQL 7.0 database(s) to a disk file, Books Online has the syntax under the BACKUP DATABASE command. Keep that backup file handy and restore it to you SQL 2000 server when you need to. You may also want to check these articles for more information:http://www.sqlteam.com/item.asp?ItemID=9066http://www.sqlteam.com/item.asp?ItemID=9465There's a nice checklist of things to consider when you migrate from 7.0 to 2000. You wouldn't have to do all of them in your case, since you'd only need to move one database to an already-existing server. |
 |
|
|
|
|
|
Save SQL 7 db to run on SQL 2000 later- steps needed