Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

backup database command,which contain backup only for 14 days. Expand / Collapse
Author
Message
Posted Wednesday, December 9, 2009 1:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
Dear ALL,

Please help..
backup database command,which contain backup only for 14 days.


Thanks

Post #831208
Posted Wednesday, December 9, 2009 2:44 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 5:55 AM
Points: 1,483, Visits: 8,545
This 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.


BrainDonor
Linkedin
Blog Site
Post #831228
Posted Wednesday, December 9, 2009 3:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:15 AM
Points: 1,159, Visits: 4,659
guptaajay1985 (12/9/2009)
Dear ALL,

Please help..
backup database command,which contain backup only for 14 days.


Please read the Jeff Moden article added in my signature.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #831243
Posted Wednesday, December 9, 2009 3:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
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.


Thanks

Post #831244
Posted Wednesday, December 9, 2009 3:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:15 AM
Points: 1,159, Visits: 4,659
guptaajay1985 (12/9/2009)
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.


Hi,
Use the maintenance plan for taking backup & Cleanup.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #831250
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse