?
Solved

ARCSERVE - Restoring an SQL DB from Tape Backup

Posted on 2009-04-28
2
Medium Priority
?
472 Views
Last Modified: 2013-12-28
I've noticed really that although my backup jobs are completing without error and indeed appear to be backing up the SQL databases to tape, when i browse the tree of objects in the restore wizard I can't see any nodes for the SQL Databases.

How would one therefore restore an SQL Database in the event of an issue?

Many Thanks,
Andrew.
0
Comment
Question by:andrewmilner
2 Comments
 
LVL 9

Accepted Solution

by:
Sai Prasad Kinnera earned 2000 total points
ID: 24254593
how about checking the database under restore by session.

incase you dont find the database information, check from the logs if the sql db was sucessfully backed up
2) go to quick start/database and click on media records and try to delete one of the tape media records which has sql database and then go to utilities and click on merge and merge the entire tape
3) this can be an issue with databse so above step will help you.

0
 

Author Comment

by:andrewmilner
ID: 24320740
Thanks for the answer.
The SQL databases are indeed showing in the session records.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
Most folks would know the basics of how Dropbox works, so that’s not the purpose of this article. Security is what it’s all about, so here I’ll share how I choose to secure my Dropbox Account and the Data it contains.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question