all groups > sql server data warehouse > april 2005 >
You're in the

sql server data warehouse

group:

Streamlining a backup database?



Streamlining a backup database? marcmc
4/18/2005 9:31:02 AM
sql server data warehouse: 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.

Re: Streamlining a backup database? JT
5/19/2005 10:56:31 AM
It sounds like the tables are vertically partitioned by time?

[quoted text, click to view]

AddThis Social Bookmark Button