-
Restore Database
Hello, every one,
I am new in SQL. I have a SQL7 back up file from a sql server, now I want to restore the file with extension .bak onto another server, but I got a message says " Device error or the device is offline ". Can any one give me some help one this.
Thanks in advance,
Bill
-
Restore Database (reply)
Was the backup copy from another SQL7 database? If it is, it is not compatible.
Otherwise, there shouldn't be any problem.
------------
Bill at 3/12/01 11:13:41 AM
Hello, every one,
I am new in SQL. I have a SQL7 back up file from a sql server, now I want to restore the file with extension .bak onto another server, but I got a message says " Device error or the device is offline ". Can any one give me some help one this.
Thanks in advance,
Bill
-
Restore Database (reply)
The big question is:
How were you trying to 'restore' ... via SQL code or Enterprise Manager?
At what point do you get the error?
Try restoring via EM (right-click database, all tasks, restore) and click the View Contents button once you have nominated the correct file via 'Select Devices' (after selecting 'From Device'.
Does it show the contents of the file?
If not ... corrupted backup or not a SQL 7 backup file.
Dale
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|