July 11, 2003 at 6:00 am
I'm having great fun with this SQL 6.5!!!
My question for today is this:
I have a backup a customer sent me - a .dat file.
I created a device and database and want to restore the .dat file into this database.
I right click, choose Backup/Restore, choose the Restore tab, From Device, Add File, navigate to the .dat file I want to restore and click OK.
The backup file shows up in the Devices and Files window instead of the Backup Information window and the Restore Now button is not available for clicking.
On another 6.5 system (with some other backups to restore), this process works fine. After I navigate to the file it shows up in the Backup Information window and I can click the Restore Now button and off it goes.
Why on this other machine does the file show up in the Devices and FIles window and not show up in the Backup Information window and why is the Restore Now button greyed out?
Edited by - deafdog on 07/11/2003 06:00:37 AM
July 14, 2003 at 8:00 am
This was removed by the editor as SPAM
July 21, 2003 at 5:59 am
Is the .dat file a true SQL 6.5 backup, or maybe the person sent you a device file.
In Query Analyser try:
LOAD HEADERONLY FROM DISK = '<fullpath>.dat'
(eg. LOAD HEADERONLY FROM DISK = 'c:\temp\mydb.dat')
...and see if SQL6.5 recognises it as a backup.
Cheers,
- Mark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply