Software

Ask something
Discussion Locked

SQL Server 7.0: integrating old database

0 helpful
5 replies

by volak_sao

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My problem is how to integrate old databse into the new one. Prior to this, we have problem running Windows NT server, so we deleted it and re-install NT server back. After installing NT, I installed SQL Server 7.0 and its SP1. It's running well butI don't know how to retrieve or integrate the old databse back into the system. Appreciate all help

5 replies

by burlynerd

The easiest way to do it would be to perform a RESTORE from your database backups and transaction logs. If you can't do that, then the following can be done.

First, make sure you make a backup copy of the db.mdf and db.ldf files (db would be replaced by the name of your database file). Next, create a new, empty database with the correct name. Detach from the newly-created database files and attach to the old files.

I haven't done this, but it should work. Now that you have asked the question, I am going to test it on my home development machines this evening. This might come in handy some day.

BN

by hypersoniq mcse

try the DTS import wizard in Enterprise Manager (Source: Microsoft OLEDB Provider for SQL Server). I don't know why you can't retrieve from a backup. BTW, SQL 7 is up to SP3.

This discussion is closed to new replies.