Show Posts
121
General / Re: List of Reports with Retention
« on: November 17, 2008, 06:55:43 AM »
This information can be easily obtained from the database.
Connect to the database and query
replace XXX with database name
Name - AG name
db_exp_date - Expiration date set for data and indexes
sid - Storage node identifier.
This data can be retrived in single shot
Rick
www.rick.co.in
Connect to the database and query
Quote
select name, db_exp_date, sid from XXX.arsag
replace XXX with database name
Name - AG name
db_exp_date - Expiration date set for data and indexes
sid - Storage node identifier.
This data can be retrived in single shot
Rick
www.rick.co.in