I'm working with a database server placed in a datacenter remotely placed from my work location, and accessing the database through Enterprise Manager and Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server in the datacenter. But I want to take backup and store backup files in my local machine. Can I do this or I have to get the files from the database server through some FTP or other protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK = N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
>
> Thanks in advance but plz do help me|||When I'm accessing the database server through the internet link so how can I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment