Is it feasible to do SQL backups based on 'Schema'? If so, how?
I have set up jobs that run in cycles (daily,weekly,monthly..) to download data from a warehouse into a SQL 2005 database. All of these tables go into 'Schema A'. There is quite a bit of data in it and once copied, the data will not be changed until the next cycle. It doesn't take a great deal of time to recreate them.
I also have created a 'Schema B' where the data miners reside. They have been told that anything that they create in 'Schema B' will be backed up nightly.
I would prefer not to have to back up 'Schema A' since I can re-create them by running the 'cycle jobs'.
Any suggestions?
Start Free Trial
