Tuesday, March 20, 2012

Backup db to another computer?

Is this the correct NG for a backup Q?
Right now I'm wondering if the only way to copy a backup file from one serve
r to
another is by DTS(?)
1. I'd like to schedule a back from one server to another recieving server t
o be
used in an emergency.
2. I'd like to be able to automate the restore of that database on the recie
ving
emergency server to reduce recovery time in the event of the primary server
becoming unavailable.
TIA
JeffP...> Right now I'm wondering if the only way to copy a backup file from one
> server to
> another is by DTS(?)
No. You can use batch files or ActiveX scripts (FileSystem object) - both
of which can be scheduled as SQL jobs.
You might look into Log Shipping - not automated for the restore but for the
backup and copy including transaction log backups.
HTH
Jerry
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:ewfxk$dfGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Is this the correct NG for a backup Q?
> Right now I'm wondering if the only way to copy a backup file from one
> server to
> another is by DTS(?)
> 1. I'd like to schedule a back from one server to another recieving server
> to be
> used in an emergency.
> 2. I'd like to be able to automate the restore of that database on the
> recieving
> emergency server to reduce recovery time in the event of the primary
> server
> becoming unavailable.
> TIA
> JeffP...
>|||You can take backup directly on remote server. You need to share drive
on remote server with proper permission.
Also you can use net use and map a drive at time of backup.
For high availability use log shipping , replication or if you are
using SQL Server 2005 you can use mirroring.
Regards
Amish Shah.

No comments:

Post a Comment