Backup and Restore

I need to backup 10 GB of data on the west coast and send over a dedicated T1
to restore on the east coast nightly. What is the best method?
Thanks.
LaEsmeralda
I would think (assuming your bandwidth is about 1.5Mbps):
1) BACKUP DATABASE MyDB ... (to a local disk (West Coast)), with
password protection (so the data doesn't get stolen in transmission)
2) compress backup file
3) send compressed file to East Coast (FTP? NTFS file copy? what kind
of tunnel do you have?)
4) uncompress file (on local disk on East Coast)
5) RESTORE DATABASE MyDB ... (on the East Coast server)), using the
backup password
Also, do you need all 10G to go every night? How much of the data is
_changed_ on a daily basis? What about a full backup (10GB presumably)
weekly & logs nightly? Assuming the modification activity against the
DB is not excessive, the logs should be considerably smaller than the
full DB backup. You might even consider a full DB less regularly (once
a month maybe?) with differentials weekly & logs nightly. Just use a
little imagination.
*mike hodgson*
http://sqlnerd.blogspot.com
PS. You're not a Victor Hugo fan are you?
LaEsmeralda wrote:

>I need to backup 10 GB of data on the west coast and send over a dedicated T1
>to restore on the east coast nightly. What is the best method?
>Thanks.
>LaEsmeralda
>
|||Your are absolutley right Mike,
Do full backup once as Mike suggested till step 5.
After that do a log dump on hourly basis or so and ship that to east coast
load it there. The log size wont be that huge. The DB i monitor have 60GB of
data. We do the above method and its running smoothly for the past 3 years.
Thanks,
Sree
"Mike Hodgson" wrote:

> I would think (assuming your bandwidth is about 1.5Mbps):
> 1) BACKUP DATABASE MyDB ... (to a local disk (West Coast)), with
> password protection (so the data doesn't get stolen in transmission)
> 2) compress backup file
> 3) send compressed file to East Coast (FTP? NTFS file copy? what kind
> of tunnel do you have?)
> 4) uncompress file (on local disk on East Coast)
> 5) RESTORE DATABASE MyDB ... (on the East Coast server)), using the
> backup password
> Also, do you need all 10G to go every night? How much of the data is
> _changed_ on a daily basis? What about a full backup (10GB presumably)
> weekly & logs nightly? Assuming the modification activity against the
> DB is not excessive, the logs should be considerably smaller than the
> full DB backup. You might even consider a full DB less regularly (once
> a month maybe?) with differentials weekly & logs nightly. Just use a
> little imagination.
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
> PS. You're not a Victor Hugo fan are you?
>
> LaEsmeralda wrote:
>