?
Solved

SQL backup to remote Server using symantec Exec 12.5

Posted on 2009-05-10
9
Medium Priority
?
437 Views
Last Modified: 2013-12-01
I have two 2003 standard servers with  sql 2005 standard on both.
one live called "datab" with symantec exec 12.5 and the sql agent and tape drive.
The other Backup server called "reserveSQL" has no tape and no Exec software.
I have a standard exec remote agent licence spare. (not sql)
Lets suppose the "datab" SQL server is dead and all I have is the tapes.
I have another server called "staff server" with exec 12.5 on it with the same tape drive that can read the tapes made by "datab" server.
The idea being that this "staff" server can somehow restore the databases to the "reserveSQL" server over the network (same domain, same subnet).
Can this be done ?
Would I need another SQL agent license to go on either the "reservesql" or "staff" server ?

Thanks



0
Comment
Question by:harveygs
[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
  • 3
  • 2
  • +1
9 Comments
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 400 total points
ID: 24349205
.."Somehow" without licenses just as files : see below:

if you do not have $$ for agent licenses
you can backup sql servers (from sql server) to backup server as bak files then to tape  
and in this case you can restore the sql backups in any DR scenario on drive and restore the db backups  to  sql server via sql server restore functionalities  (e,g from SSMS, t-sql)

also in case - there is not much space on server drive : you can have compressed (fast too)  sql backup via 3rd party SW backup Idera:sqlsafe; Quest: SQLLiteSpeed,  etc


0
 
LVL 1

Author Comment

by:harveygs
ID: 24349243
I could get another sql agent if it would help with restoring accross the network.
Is this the sort of thing an sql agent can do?

Or yes could schedule a db.bak file and put that on tape, then copy paste to backup server. snd re-atach , import whatever.

Whats the easiest ?
0
 
LVL 23

Accepted Solution

by:
Rahul Misra earned 1200 total points
ID: 24352770
Well you just need to install the remote agent and restore to the other (RESERVE) SQL  server at any time. Even when the one in production is still up.
The reason you would need the remote agent is that is uses the SQLVDI.DLL that allows backups and restores
there is no special SQL agent its the RAWS that you install on all windows servers to back up various resources.
The license once entered allows you to view the specific resources so that they can be backed up.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 16

Assisted Solution

by:Wadski
Wadski earned 400 total points
ID: 24352812
What is to stop you transferring the remote agent licence from the 'dead' server to the reserve server before restoring the database? There is no licensing or cost implications only a slight delay putting the licence on there.
0
 
LVL 1

Author Comment

by:harveygs
ID: 24352928
Thanks for comments so far.
I think it would be easier to get the sql agent and put the remote agent on the backup server.
Wadski.. Does the licence get authenticated by Symantec otherwise i only want to use the one licence at a time, will it come up and say licence already used ?

0
 
LVL 23

Expert Comment

by:Rahul Misra
ID: 24352985
you can put a license on a remote server
just need to install the remote agent
0
 
LVL 23

Expert Comment

by:Rahul Misra
ID: 24352987
YOU CANNOT
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24353291
still I would recommend to use sql server  backup to backup folder then to tape instead of BE sql server backup:

During DR you will need minimum SW to get your sql server running, etc..
And easier to do database administration... however, it is up to your business requirements
0
 
LVL 1

Author Comment

by:harveygs
ID: 24355475
OK finalised on this :-
backup server (reserve SQL) has a basic agent on it .
Production server "datab" with Exec and SQL agent.
"Staff " server has only the Exec on it.
When tape inserted to "staff " server it seems to switch on the SQL options. It happily sent accross the test database  to the backup "reservesql" server with security etc.
So answer is I dont need any other agent licences.
But I will also use the .bak option as . Belt and braces as the saying goes !
Thanks
Now  to the points....

0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

777 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