Prev: Suspended bcp
Next: loop
From: xpander on 3 Jun 2010 21:26
What would be the fastest way to copy a SQL Server 2005 database and its data
to another server including keys and constraints, without stopping the source
server?
TIA
From: Dan Guzman on 3 Jun 2010 21:34
> What would be the fastest way to copy a SQL Server 2005 database and its
> data
> to another server including keys and constraints, without stopping the
> source
> server?

BACKUP/RESTORE

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/



 | 
Pages: 1
Prev: Suspended bcp
Next: loop