September 4, 2007 at 3:34 am
Hi.
In one of my client place where SQL 7.0 is installed, we're unable to restore a backup file. When we right click the database and select restore, the 'options' tab doesn't show the filenames. Also in properties, we are unable to the tab 'Data Files'.
Please help how to solve this. Operating system of server is 2000.
Bharat.
September 4, 2007 at 3:56 am
How many files do you have associated with the database
In case you are not able to restore from the GUI. Why dont u consider the option of
Restore database
September 4, 2007 at 4:17 am
Thanks for the reply. However what i don't understand is how the tabs are not shown ? Can you give me the command for restore ? From where it is executed ?
September 4, 2007 at 4:31 am
First run
RESTORE HEADERONLY FROM DISK = N'c:\myBackup.bak'
just fill in the backup path.
This will give you information about what backup sets there are in this backup file, whether they are damaged, the version of the server that has created them, etc.
Andras
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply