Chris Mackin
chris at denverdb.com
Sat Aug 30 21:34:17 CDT 2003
You can either look into the sp_attach and sp_detach procedures or simply back up the databse on the server running it and restore the backup on the other sql server. Either way is quite simple and effective. Chris Mackin Denver Database Consulting, LLC www.denverdb.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 8:25 PM To: SQLServer; AccessD Subject: [dba-SQLServer][AccessD] 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com