I need to create a copy of my database (sql server 2005) that I can allow someone else to download off of my web server & install the copy on their local machine.
Take a full backup, zip it and link it from your website. If you don't want to share the data just create a script using the wizard in management studio: Right-click the database you want to publish -> Tasks -> Generate script
- Lumbago If the facts don't fit the theory, change the facts. Albert Einstein
You could also DETACH the database, Zip up the MDF and LDF files, and put that on your website. But my preference would be a Backup file too.
Make sure the "empty" database is not too big when you back it up - it will restore to the same initial size (100GB might be a surprise for the new owner!). (Same is true of DETACH method of course)
How do I create a copy of a sql database?
Posted - 02/02/2010 : 02:15:03
