October 22, 2008 at 12:04 am
I have an SQl Server with several DB on it. Backups are running successfully in Maintenace Plans.
If I want to restore a DB with the Management Studio, the Backups Sets to restore are not displayed.
This problem not appears on all DB.
October 23, 2008 at 4:27 am
do your backup set having the extension of .bak ? If not try to add in and see if its appear ?
October 23, 2008 at 2:39 pm
Well the backup sets are not displayed by default. You have to direct SQL server to look up for the backup file. Here you need to show it the type of backup it is like tape or disk( device backup0) and in some cases if the backup is stored on the network you will have to say something like \etwork name\share folder name\filename.bak
If it is located on a drive then you would need to do a restore from device and then click on the 'add' tab from there select the directory on which your backup file sits...
Hope this helps..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply