SQL Backups with External USB HDD

9 Sep 2005 11:35 PM

jtart2

I have two offices and SQL Server in each office. I use a USB External
Harddrive to back up my databases every night.

Is it possible to back up a SQL Server database onto a USB Memory stick or
external harddrive and transfer the database/tables to another SQL Server at
another location? Kind of like with a MS Access database.

I'd like for each office to have a back up copy of the others database just
in case there is ever an "accident".
Thanks for your help!

10 Sep 2005 12:25 AM

Andrew J. Kelly

Sure. You can take a backup anywhere as long as you can fit it on the
drive. Then just restore it to the other machine.

--
Andrew J. Kelly SQL MVP

Show quote

"jtart2" <jta***@discussions.microsoft.com> wrote in message
news:1294C17D-0620-49BE-AEDA-F6B32975A4EA@microsoft.com...
>I have two offices and SQL Server in each office. I use a USB External
> Harddrive to back up my databases every night.
>
> Is it possible to back up a SQL Server database onto a USB Memory stick or
> external harddrive and transfer the database/tables to another SQL Server
> at
> another location? Kind of like with a MS Access database.
>
> I'd like for each office to have a back up copy of the others database
> just
> in case there is ever an "accident".
> Thanks for your help!