way to back up sql server 2005 database to just get the data and objects

Posted by Caveatrob on Server Fault See other posts from Server Fault or by Caveatrob
Published on 2012-09-10T20:15:16Z Indexed on 2012/09/10 21:40 UTC
Read the original article Hit count: 87

Filed under:

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?

© Server Fault or respective owner

Related posts about sql-server-2005