?
Solved

SQL Restore - Backup Exec 11d

Posted on 2009-05-12
5
Medium Priority
?
955 Views
Last Modified: 2013-12-01
I need some help with a Redirected SQL Restore.  I thought I had it down and when the restore job ran, what happened next is both unexplainable and unwanted.

I used a previous, successful B2D job as my restore point so I would not be touching the actual, production DB which was in use.  I configured the restore job to send the restore to a different folder/directory location than the original DB resides.  All permissions/credentials in place and working.  Windows Server 2003 SP2 and Symantec Backup Exec 11d.

So, when the restore job started it looked as if it were running but on the other end, what happened was it began to restore the LIVE DB, thus freezing out any users who were working in that live DB at the time.  Also, the restore job automatically(?) sent the restore to the original DB directory instead of the redirected path I had specified during the configuration/setup of the restore job.

I cannot - CANNOT - have something like that happen again but I DO need to run a successful SQL restore to prove to my boss and the higher-ups that we can restore the DB's if needed.  

SO - I am VERY novice when it comes to server side stuff and backups, but nonetheless, I have to figure this out....

Specific Questions I have:

Why did the restore job not restore the DB to the redirected location that I had specified during job setup?

Why did the restore job pull the live DB data instead of from the B2D job that I had specified during job setup?

Why did the live DB go "offline - restore in progress" when there was nothing (that I know of anyway) that told the restore job to even touch the live DB?

This is a huge issue here and I'm at a loss for what to do next, let alone understanding what went wrong before.

Any help you can provide would be greatly appreciated.

Thanks!
0
Comment
Question by:noncexstanza
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 24374426
When you restore a SQL Database; Under the 'Destination' - Microsoft SQL Redirection tab you also need to specify the server to redirect to, the database name (i.e. LiveData_RESTORE) and you also need to specify a path under destination which is NOT your live SQL data folder.

As by the sounds of things you didnt specify this; it would assume that from the backup selection you selected; it assumed as you didnt tell it otherwise to overwrite the existing database.

The database would go off-line as it cant be open when you're restoring it.

HTH
0
 

Author Comment

by:noncexstanza
ID: 24385979
The live DB's reside on Server 05 and the Backup Server (B2D jobs) are on Server 03.  

What I want to do is setup a SQL Restore using the B2D jobs stored on Server 03 and restore to a different directory on Server 03.  Doing so, should keep the live DB on Server 05 untouched. Right?

0
 
LVL 13

Expert Comment

by:St3veMax
ID: 24386013
You should do; Just make sure you specify a different name and directory in the SQL Redirection area.

HTH
0
 

Author Comment

by:noncexstanza
ID: 24436962
Question -

I heard that when running a redirected SQL restore that it MUST be redirected to a specific SQL Instance.  Server03 (our backup server) also has SQL 2005 running and the instance created by Backup Exec is named: BKUPEXEC.

Is it possible to run the redirected SQL restore to that SQL instance (BKUPEXEC)?  
0
 
LVL 13

Accepted Solution

by:
St3veMax earned 1500 total points
ID: 24438798
Erm...Not sure where you got that from.

You can redirect a SQL Restore server provided: 1) It has SQL Server and 2) It has the BE SQL Agent.

You can put it on that instance, but it only supports DB's upto 4GB, so it may not work if it's over.

HTH
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Suggested Courses

764 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