Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to do a nightly backup of a SQL Server 2005 database to get the leanest, smallest file that includes all the table data, stored procedures, views, and functions.

I'm downloading and saving this daily in case the server isn't available and I need to just get some data out. I don't care about the logs or any other parts of the DB but the data, procs, tables, and functions.

What's the easiest way to get just this information backed up?

share|improve this question
A proper SQL Backup is the best way to get a backup of your database. –  user3914 Sep 10 '12 at 21:06
You ignored my question - I only want the data, procs, and tables, not the logs or any extra stuff. This is solely for reference and doesn't require any log backups or anything - just the smallest possible backup I can get. –  Caveatrob Sep 10 '12 at 21:35
I did not ignore your question. Also, have you ever compressed a SQL backup file? Depending on the data, you can get up to 90% compression. And it's a darn sight easier to recover than a script. But hey, if you want to ignore best practice, go ahead. –  user3914 Sep 10 '12 at 21:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.