How do I restore one SQL7 database to another, of a same name, on a different server.

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

As a disaster recovery test, I have built a 2nd MSSQL7 database server as a copy of my original database server. Both server 1 & server 2 contain databases of the same name. The database on server 1 is fully populated with data, the database on server 2 has an identical structure, but contains no data.

Using Enterprise Manager on server 2, I have tried to use a backup of the original populated database on server 1, to restore to the empty database on server 2. However, SQL7 does not allow me to do this.

Am I going about this the correct way??

-- Anonymous, April 03, 2003

Answers

Chris,

A database restore does not want to use the structure of an existing database. If you want to use the existing structure on server 2, you will need to use the Export Wizard to copy the data to it.

Hope this helps,

Eric

-- Anonymous, April 04, 2003


Moderation questions? read the FAQ