95% of my database size comes from a handful of large tables (as is
typical). But in development, when I want to get at an old version of
something other than those tables, I don't want to have to restore 50
GB. So I have another database which has everything the main database
has, except the data in those few big tables. Both databases are backed
up nightly.

My question is, how can I re-fill the small database each night prior to
the backup, making sure it gets any new tables & stored procs, and all
the new data, but *excluding* the big tables?

Any thoughts on how to do this with the least amount of work?

Thanks in advance!

Charlie




*** Sent via Developersdex http://www.developersdex.com ***

You could place the large tables on there own file / filegroup in
production. Each night backup / restore at the file level..

--
HTH. Ryan
"Shishu Das" <shishuda91 (AT) gmail (DOT) com> wrote