03-03-2015 09:53 AM
We are using Backup Exec 2012 with the SQL agent to back up several SQL Express 2008 R2 DBs.
I went to restore a database and the instance is not listed, even though I see in the logs it is getting backed up.
The three instances that are showing, are not listing any of their databases.
Any thoughts?
Thank you.
Solved! Go to Solution.
03-05-2015 07:11 AM
03-03-2015 11:51 PM
...did you use Advanced Open File Option when backing up the SQL DBs?
Thanks!
03-04-2015 12:53 AM
Are any of the instances related to Sharepoint?
03-04-2015 05:15 AM
Colin: No Sharepoint here. Thanks though.
Craig: Checked the job settings and yes it is active for that job.
03-04-2015 10:54 AM
In general, snapshot technology is not recommended for database backups.
However can you please browse the backup sets and check if the databases are listed under the instance?
03-04-2015 11:00 PM
Have you backed up the SQL DBs to tape or to disk ? if to tape, duplicate the backup sets to disk and recheck.
Secondly, is BE 2012 completely updated with the latest patches / hotfixes ? (At least SP4 should be present)
03-05-2015 05:16 AM
Even though the job runs 5 times a week, the last backup set is from Oct. 2014. Strange.
Backup is to tape.
LiveUpdate reports no updates needed.
03-05-2015 07:11 AM
03-05-2015 01:41 PM
Thank you all for your help. Turns out there was a job running after this job that was set to overwrite instead of append.
Thanks again everyone.