Solved

SQL backup to remote Server using symantec Exec 12.5

Posted on 2009-05-10
9
431 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:
Iamthecreator 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
 
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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:Iamthecreator
ID: 24352985
you can put a license on a remote server
just need to install the remote agent
0
 
LVL 23

Expert Comment

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

New! My Passport Wireless Pro Wi-Fi Mobile Storage

Portable wireless storage to offload, edit, and stream anywhere.

High-capacity, wireless mobile storage designed to accompany professional photographers and videographers in the field to easily offload, edit and stream captured photos and high-definition videos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Netapp and Vcenter report 9 81
what is the diffrence between the snapshot and full backup? 5 87
Veeam backup Catalog 6 84
Query 14 54
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now