cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL restore

Kimmy_Shun
Level 5

I can see in job log that the DB has been backup successfully. But when I tried to restore DB, I cannot see the date for me to select in the wizard. Please refer to attached screen. Thanks

2 REPLIES 2

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...do you have Advanced Open File Option running on the job? If so, this isn't recommended when backing up databases.

Try to duplicate the SQL database from tape to disk and see if this works.

Also make sure that the retention time for the catalogs isn't set to something less than the period of time you're looking at.

Thanks!

VJware
Level 6
Employee Accredited Certified

Are the backup sets still present on the storage ?

If yes, try inventorying and cataloging the storage device and check if the backup sets are visible or not.