John Colby
jcolby at colbyconsulting.com
Sat Aug 30 22:04:12 CDT 2003
Thanks for this info. I'll try the backup. Never done an SQL Backup actually. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Chris Mackin Sent: Saturday, August 30, 2003 10:34 PM To: dba-sqlserver at databaseadvisors.com; AccessD Subject: RE: [dba-SQLServer][AccessD] Moving SQL Server db 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 _______________________________________________ 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