November 2, 2007 at 2:20 am
Hi Guys,
I am currently using a script to back up one of my databases. The database isis not situated locally. With Maintenance Plans in SQL 2000 you have to create a backup and have the retention period included with the maintenance plan. You can't create a step for the retention period only.
Does anyone perhaps have a script set the retention period. I want to add it in a step of my job that backs up the database.
Regards
IC
November 2, 2007 at 7:15 am
I am not clear with the question as it raises doubt for me. You are asking a 2000 question in 2005 forums if i am not wrong.
you have the option to have retention in 2000 databases tooo.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 2, 2007 at 7:18 am
I know you have an option for retention period in 2000. I am looking for a script that can do this as well.
IC
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply