MS SQL Data Warehousing - Streamlining a backup database?

Author

Streamlining a backup database?

marcmc

2005-04-18, 11:23 am

I have a requirement for an automated process to streamline warehouse backups
(some tables only) to only 4 weeks of data for each table archived. I have a
system whereby I apply a suffix to ensure unique table names.

We have alot of old data that builds up quickly. In the near future I will
be deleting uneccessary table and implementing the new approach.

Any ideas or experiences of a similar problem much appreciated.

Marc

2005-05-19, 11:23 am

It sounds like the tables are vertically partitioned by time?

"marcmc" <marcmc@discussions.microsoft.com> wrote in message
news:A5328708-DAC9-4E23-9742- 166531222081@microso
ft.com...
> I have a requirement for an automated process to streamline warehouse
backups
> (some tables only) to only 4 weeks of data for each table archived. I have
a
> system whereby I apply a suffix to ensure unique table names.
>
> We have alot of old data that builds up quickly. In the near future I will
> be deleting uneccessary table and implementing the new approach.
>
> Any ideas or experiences of a similar problem much appreciated.
>
> Marc

Sponsored Links