Transaction backup set Not to expire after 2 days why????

Question

question

askmlx121 asked Mar 13, '13

Transaction backup set Not to expire after 2 days why????

I created a Maintenance Plan to do a Transaction log backup hourly basis and set the backup set to expire after 2 days. Weeks later, old backups of every one hour in the extension of .trn are sitting on the hard drive in the installation directory and I have to manually delete them. Here is a screen shot of what the plan looks like ![alt text][1] What am I doing wrong? [1]: /storage/temp/712-tlog+maintenance+plan.jpg

transaction-log backups

tlog maintenance plan.jpg (95.8 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-03-13T09:00:34Z

Nash9991 answered Mar 13, '13

Hi Ashok, 2 things to look out for: 1)In your Maintenance Cleanup Task ensure that the tickbox where it states "Include first-level subfolders" is ticked - but only do this if you have ticked "Create a sub-directory for each database" in your Backup Database Task. 2) Ensure that the account on which the job is running, has delete permissions to the folder where you are backing up the DBs to. Please let me know if this helps...

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nash9991 commented · Mar 13, 2013 at 09:17 AM

You welcome. Did you run the job again to see if the backups are deleting?

1 ·

askmlx121 commented · Mar 13, 2013 at 09:15 AM

Yes its help me a lot........ i followed your valuable two points its helped me...thankxxxxx

0 ·

askmlx121 commented · Mar 13, 2013 at 09:28 AM

Yes I ran the job it has deleted the old backup files older than 2 weeks successfully. Actually the problem was Tlog backup folder was in read-only mode and i did nt tick 'Include first-level subfolders'

0 ·

Answer 2 · 2013-03-13T10:08:47Z

ramesh 1 answered Mar 13, '13

it is not advised to set expiry for backup sets.... these backup sets mays some times help you in disaster, there is no benefit of setting expiry for a backup set. what do u think

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nash9991 commented · Mar 13, 2013 at 10:54 AM

Nicely spotted Ramesh. I missed that completely. I do agree, the backups will be useless if they are sent to tape as they cannot be used a month later...

0 ·

askmlx121 commented · Mar 13, 2013 at 11:59 AM

I want to ask one doubt In F drive I stored Tlog backup files of .trn file are there In E drive database .mdf,.ldf files are there we run Transaction log backup every hour basis but still .ldf,.mdf files not reduced or growing large why?

0 ·

Answer 3 · 2013-03-13T11:56:10Z

askmlx121 answered Mar 13, '13

Hi ramesh,Nash I agree to maintain 1 month tlog backup but due to not enough space in Drive F because When Transaction log fails due to Daily Backup of Database not availability or switch the model from simple to full then it size raises too large actually size of db is **1 MB** but it raised to **85 GB** when it came from fails but again it normals..why? see the pic for your understanding ![alt text][1] [1]: /storage/temp/713-tlog+size+too+big+when+came+from+fail.jpg

tlog size too big when came from fail.jpg (213.7 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question