control of tables backed up
I have created a couple of additional control tables in the SD database containing essentially static data I use to provide some additional reporting functionality - grouping SLA's together as one reporting entity for instance.
No UI issues and reporting works fine.
The thing that has just tripped me up is the backups, they are obviously controlled by a list somewhere of the table names it should backup.
So I did a full backup and the restored to a test instance to carry out an upgrade/dr test and found some of my custom reports stopped working, because they use my custom tables!
For want of going further outside the norm, is it possible to customise the list of tables that are backed up and if so how.
Just don't want to have to rely on the OS level database backups if I can help it.
Kind Regards,
Andy
SDP 7603 - Windows 2003 & SQL 2008
No UI issues and reporting works fine.
The thing that has just tripped me up is the backups, they are obviously controlled by a list somewhere of the table names it should backup.
So I did a full backup and the restored to a test instance to carry out an upgrade/dr test and found some of my custom reports stopped working, because they use my custom tables!
For want of going further outside the norm, is it possible to customise the list of tables that are backed up and if so how.
Just don't want to have to rely on the OS level database backups if I can help it.
Kind Regards,
Andy
SDP 7603 - Windows 2003 & SQL 2008