Backup on a remote server

I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and both partitions are mirrored. One is for system and the other one I'm using for database. I'm doing a comlete daily backup of 2 critical databses which eats up 500MB per database. My question is, is it possible to use a remote server or storage and configure SQL to automatically backup those databases there? Because when I tried to map a storage that I want to use forthe backups, I didn't see it in the "choose backup destination". What I'm basically doing now is to backup the databases in the system partition on the SQL server and move it to the remote storage manually from time to time. Do you know of any simpler method
Thank youYou can use a network share, it is just Enterprise Manager that is limited
to local disks, if I remember correctly. With Backup T-SQL statement you can
use remote shares as well. And you can use a scheduled to execute this
command regularly. Do please read about the Backup command and scheduled
jobs in Books OnLine if this is what you need.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
> Thank you.
>|||Hi,
Enterprise manager will not show the network drives, Steps to perfom a
backup across network and schedule to run,
1. Create a backup device using sp_addumpdevice command (Sp_addumpdevice
'disk','dbname_bak','\\networkservername\sharename\dbname.bak'
2. Create a batch file (backup.bat)
3. Inside the batch file
net use k: \\networkmachine\sharename /user:OS_username password
isql -Uuser -Ppassword -S server -Q'backup database dbname to
backupdevice with init" (use the device name create in step1)
net use k: /d
4. Save this contents in Backup.bat
5. Schedule this batch file using SQL Agent , In the Job step select the
type as "Operating system command"
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OMK5poS9DHA.2472@.TK2MSFTNGP10.phx.gbl...
> You can use a network share, it is just Enterprise Manager that is limited
> to local disks, if I remember correctly. With Backup T-SQL statement you
can
> use remote shares as well. And you can use a scheduled to execute this
> command regularly. Do please read about the Backup command and scheduled
> jobs in Books OnLine if this is what you need.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
> news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> > I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2
and
> both partitions are mirrored. One is for system and the other one I'm
using
> for database. I'm doing a comlete daily backup of 2 critical databses
which
> eats up 500MB per database. My question is, is it possible to use a
remote
> server or storage and configure SQL to automatically backup those
databases
> there? Because when I tried to map a storage that I want to use forthe
> backups, I didn't see it in the "choose backup destination". What I'm
> basically doing now is to backup the databases in the system partition on
> the SQL server and move it to the remote storage manually from time to
time.
> Do you know of any simpler method?
> >
> > Thank you.
> >
>|||Hi,
It works fine to backup to a remote server with a maintenance plan! Just map
a network drive to the remote server share and manually type (browsing won't
work) this drive letter in the "Use this directory" field on the maintenance
plan property page. Don't forget to make the sql server service use an
account with sufficient permissions on the remote server though.
/Roger
"Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
> Thank you.
>