Discussion Locked

Restoring DataBase on SQL 7.0

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, I have taken DB backups of my SQL 7.0 DB Server into file as "proj1.dmp" of SQL7.0, nw how do I retore it ? I tried but it says that a vaild copy is running. We also have Oracle 8i, I have dmp of other Databases also, how do I retore them ? How do I install Oracle Management Server ?
Akash

3 replies

by nt/2000/sql

You should know that your file can only be restored on SQL Server 7.0

If you get this message then try either to rename the databases on your server having the same name then those on the backup, or use the "With No CHECK" clause in the restore command. This will cause the running databases to be overwritten.

This discussion is closed to new replies.