[dba-SQLServer]Moving SQL Server db

Eric Barro ebarro at afsweb.com
Sun Aug 31 01:10:28 CDT 2003


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




More information about the dba-SQLServer mailing list