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
Solved

SQL backup to remote Server using symantec Exec 12.5

Posted on 2009-05-10
9
434 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
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 100 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 300 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 16

Assisted Solution

by:Wadski
Wadski earned 100 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 42

Expert Comment

by:EugeneZ
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
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 tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
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…

856 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