[dba-SQLServer] Copy database question

Mackin, Christopher CMackin at quiznos.com
Wed Nov 24 12:05:35 CST 2004

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
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?



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

More information about the dba-SQLServer mailing list