[dba-SQLServer]Moving SQL Server db

Or detach/reattach.


>From: "Eric Barro" <ebarro at afsweb.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]Moving SQL Server db
>Date: Sat, 30 Aug 2003 23:10:28 -0700
>
>John,
>
>Backup the DB and then restore to the other machine.
>
>---
>Eric Barro
>Senior Systems Analyst
>Advanced Field Services
>(208) 772-7060
>http://www.afsweb.com
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John
>Colby
>Sent: Saturday, August 30, 2003 7:25 PM
>To: SQLServer; AccessD
>Subject: [dba-SQLServer]Moving SQL Server db
>
>
>I need to move my SQL Server databases from SQL Server running on my server
>to SQL Server running on my desktop.  Is there an easy procedure for doing
>this?
>
>John W. Colby
>www.colbyconsulting.com
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus