Moving a big database

What is the best way to move a 15gb database. Copy the
files from 1 server to the other (the network connection
is pretty quick) or to backup then restore using a DAT
tape?Probably sp_detach_db and sp_attach_db.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"mat" <anonymous@.discussions.microsoft.com> wrote in message
news:11c3001c410c4$f7b18fe0$a301280a@.phx
.gbl...
> What is the best way to move a 15gb database. Copy the
> files from 1 server to the other (the network connection
> is pretty quick) or to backup then restore using a DAT
> tape?|||Hi,
I too agree Tibers comments. Because the backup of 15 GB database will take
20 Minutes and then Restore will take another 30 minutes. But if you go with
Tibers comment it will just take only copy time from source to destination.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OcXNXZMEEHA.2424@.TK2MSFTNGP09.phx.gbl...
> Probably sp_detach_db and sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "mat" <anonymous@.discussions.microsoft.com> wrote in message
> news:11c3001c410c4$f7b18fe0$a301280a@.phx
.gbl...
>|||And if you need to do this 'move' on a regular basis you should really check
out SQL Lite Speed which will compress the backup as it's happening. This
will save a LOT of space, but more importantly will make the file copy a lot
faster since the file is a lot smaller...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:eA7XnzMEEHA.1128@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I too agree Tibers comments. Because the backup of 15 GB database will
take
> 20 Minutes and then Restore will take another 30 minutes. But if you go
with
> Tibers comment it will just take only copy time from source to
destination.
> Thanks
> Hari
> MCDBA
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OcXNXZMEEHA.2424@.TK2MSFTNGP09.phx.gbl...
>