Backup on a remote server

I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and bo
th partitions are mirrored. One is for system and the other one I'm using f
or 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 configu
re 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 pa
rtition on the SQL server and move it to the remote storage manually from ti
me to time. Do you know of any simpler method?
Thank you.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,
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...
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?
>|||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.
>

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.
>

Backup log With Truncate Only (Log Shipping)

SQL Server 2000 Standard Edition running on Win2k
I've setup log shipping according to an article I found here.
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Which truncates the log before doing the database backup then does the backup
and
subsequent log backups without truncating. Of course the truncate causes an
error
to be shown in the event viewer.
Since books describes the default behavior of log backups to be an automatic
truncate
after backup my initial thought is to drop the log backup before the db backup
and just let
the truncate happen automatically with the normal log shipping backups.
Remove This -- BACKUP LOG database_name WITH TRUNCATE_ONLY
Remove This -- WAITFOR DELAY '00:00:05'
BACKUP DATABASE database_name TO database_name_backup_device WITH INIT
Remove the NO_TRUNCATE and let the log truncate automatically.
BACKUP LOG database_name TO log_backup_device WITH INIT, NO_TRUNCATE
They do mention in the article that you don't want to truncate the log after
you do
your normal log shipping backups because you might need them later. Would you
possibly
need them later? I archive all my log and db backups each time they run.Brad <seveni7@.yahoo.com> wrote:
>SQL Server 2000 Standard Edition running on Win2k
>I've setup log shipping according to an article I found here.
>http://www.sql-server-performance.com/sql_server_log_shipping.asp
>Which truncates the log before doing the database backup then does the backup
>and
>subsequent log backups without truncating. Of course the truncate causes an
>error
>to be shown in the event viewer.
>Since books describes the default behavior of log backups to be an automatic
>truncate
>after backup my initial thought is to drop the log backup before the db backup
>and just let
>the truncate happen automatically with the normal log shipping backups.
>
My bad!
Found it on MS Knowledge Base Article - 818202
Just a warning.