Steve Conklin (Developer@UltraDNT)
Developer at UltraDNT.com
Wed Nov 24 12:29:09 CST 2004
Backup/Restore WILL bring bring along the data, scripting will not. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mackin, Christopher Sent: Wednesday, November 24, 2004 1:06 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Copy database question Backup the source database and restore it as the new one. Chris Mackin -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Wednesday, November 24, 2004 10:53 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Copy database question I want to copy a database containing 100+ tables, about 500 sprocs and about 200 views and about 20 UDFs to a new database, but with the proviso that no data goes, only the structures. I'm not sure how to do this. Suggestions? TIA, A. > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.1 - Release Date: 11/19/2004 _______________________________________________ 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