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