copy entire database?

[Sheffield]

Greetings,

Is it possible to copy an entire database (stored procedures, diagrams, tables, DTS packages, etc...) to a CD?

It would make sense that Microsoft would have created an automated way to do this, but I just don't know how?

Thanks,

 

[vanuta]

One way to copy your database to cd is to copy the actual database file. Usually I store all my database files in the mssql7 folder.

Hope this helps.

 

[outofservice]

Are you saying here that you wish to copy all data contained within the database too or just the structure?

Why dont you just copy the following files to the cd ... 'databasename'.mdf, master.mdf and Msdbdata.mdf. You would then need to re-attach to sql server when they are copied back from the cd to disk. Lauryn Bradley
SQL Server DBA

 

[tlbroadbent]

Do you want to store the actual database or scripts to create the database? If storing the database, do you want the data or just the structure? Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[Sheffield]

My goal would be to have everything that comprises the Database. All the tables. All the stored procedures. All the views, diagrams, etc... I think you get the picture.

I wish to store the acutal database, not merely scripts to recreate it.

Will copying the *.mdf & *.log files do the trick?

 

[tlbroadbent]

In order to copy the MDF and LDF files you will need to detach the database from SQL Server, copy the files and reattach. I would recommend creating a backup and copying the backup to CD. The backup can be retored very easily.

NOTE: If your databsae is very large you will encounter difficulties copying to CD unless you have copy software that can split a file across multiple CDs. We have many databases that are larger than to 700MB a CD can hold. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[SteveMac32]

You could also create a backup in enterprise manager, then create a new database and restore to it using the backup.