Hi,

We have a standby server that is located at the remote site connected by a
leased line. We have a log shipping that is currently running from our
primary server located at hq to the standby server. Everyday there will be a
transaction logs and the full database restore been done on the standby
server. The transaction logs and the full database file will be copied over
to the remote site.

The problem with have right now is that our database is getting bigger and
bigger, the leased line bandwith that we have cannot cope with the size of
the full database file. We end up with a few hours of copying the full
database file to the remote site.

How do we overcome this problem ? Can we just moved the transaction logs and
restore it ?

Thank you.

Regards,
Zul

I am not too clear on the question, but if the full
database backup has been transferred and restored to the
standby server and log shipping is set up, there is no
further requirement to transfer the database backups. If
it is not yet set up, then if you establish a time when
users can't access the system, you can backup the primary
server's database, zip it up and transfer it. Unzip at
the other end and restore with no recovery or with
standby, and then set up log shipping from scratck while
selecting the option that a database backup is not
required.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Dear Paul,

In other words, what you are trying to say is that I just need to restore
the full database backup only once on the standby server with the option of
"Leave database read-only and able to restore additional transaction logs",
then I can just only transfer the transaction logs files and restore it at
the standby server with the same option.

What if a full database backup has been schedule to run everyday on the
production server, will I still be able to just copy the transaction logs to
the standby server and restore it without restoring the full database backup
on the standby server ?

Thank you.

Rgrds,
Zul


"Paul Ibison" <Paul.Ibison (AT) Pygmalion (DOT) Com> wrote

Exactly! - the database backup doesn't backup the log's
contents so allows log shipping to continue as per usual.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)