InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 20:19:10 GMT20http://www.sqlservercentral.com/Forums/Topic831208-146-1.aspx[quote][b]guptaajay1985 (12/9/2009)[/b][hr]Dear Brain,Thanx to reply..I am explaining suppose..I have started it at today 9-12-09.Now I have the backup of up to 23-12-09.Now on 24-12-09 automatically the backup of 9-12-09 will be deleted.but from 10 to 24 I have backup.Now on 25-12-09 automatically the backup of 10-12-09 will be deleted.but from 11 to 25 I have backup......Now on 25-12-10 automatically the backup of 10-12-10 will be deleted.but from 11 to 25 I have backup.[/quote]Hi,Use the maintenance plan for taking backup & Cleanup.Wed, 09 Dec 2009 03:13:57 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic831208-146-1.aspxDear Brain,Thanx to reply..I am explaining suppose..I have started it at today 9-12-09.Now I have the backup of up to 23-12-09.Now on 24-12-09 automatically the backup of 9-12-09 will be deleted.but from 10 to 24 I have backup.Now on 25-12-09 automatically the backup of 10-12-09 will be deleted.but from 11 to 25 I have backup......Now on 25-12-10 automatically the backup of 10-12-10 will be deleted.but from 11 to 25 I have backup.Wed, 09 Dec 2009 03:06:22 GMTforsqlserverhttp://www.sqlservercentral.com/Forums/Topic831208-146-1.aspx[quote][b]guptaajay1985 (12/9/2009)[/b][hr]Dear ALL,Please help..backup database command,which contain backup only for 14 days.[/quote]Please read the Jeff Moden article added in my signature.Wed, 09 Dec 2009 03:05:32 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic831208-146-1.aspxThis isn't clear Ajay, do you mean you want to create a backup that is retained for 14 days or do you have a backup that has a 14 day retention and have a problem with it?If you want more information on retention, just look at BOL - 'BACKUP DATABASE'.BrainDonor.Wed, 09 Dec 2009 02:44:17 GMTBrainDonorhttp://www.sqlservercentral.com/Forums/Topic831208-146-1.aspxDear ALL,Please help..backup database command,which contain backup only for 14 days.Wed, 09 Dec 2009 01:40:39 GMTforsqlserver