Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Policy based management

Author  Topic 

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-11-09 : 06:28:47
Hi to all,

I have database with 3.5 years of data.Application user want to archive data,and application also have that option.

But in database 2 years of data should be available. So application user can archive more then 2 years data only.

For that i am thinking to create a policy,so now i wanted to know that is possible or not ? and that is good idea or not ?

or there is any other way to do this ? please help me with this.

Thanks





Manju
   

- Advertisement -