 | |
SQL Setup Recomendation - Maintenance Plan Not Removing .bak files
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#71
 
| |||
| |||
|
Re: SQL Setup Recomendation - Maintenance Plan Not Removing .bakfiles -
10-28-2008
, 07:29 AM
|
If you are sure that jobs run successfully (right click on the plans and see their histories) then ensure that you type a correct file extension, which is "bak" without the apostrophes. And ensure that you type a correct path for the back up files which are supposed to be deleted after a period. These are the common problems I see when someone complains about deleting old backups using amaintenanceplan. |
dumber and simpler than that.
Be sure you enter your extension without the period. e.g. "bak",
not ".bak". Otherwise the file matching rule will never match your
backup files (it is looking for "foo..bak" and not "foo.bak", and the
Maintenance Plan editor will quite happily let you do this.
<smacks forehead>
ouch!
#72
| |||
| |||
|
|
If you are sure that jobs run successfully (right click on the plans and see their histories) then ensure that you type a correct file extension, which is "bak" without the apostrophes. And ensure that you type a correct path for the back up files which are supposed to be deleted after a period. These are the common problems I see when someone complains about deleting old backups using amaintenanceplan. |
dumber and simpler than that.
Be sure you enter your extension without the period. e.g. "bak",
not ".bak". Otherwise the file matching rule will never match your
backup files (it is looking for "foo..bak" and not "foo.bak", and the
Maintenance Plan editor will quite happily let you do this.
<smacks forehead>
ouch!
#73
| |||
| |||
|
|
If you are sure that jobs run successfully (right click on the plans and see their histories) then ensure that you type a correct file extension, which is "bak" without the apostrophes. And ensure that you type a correct path for the back up files which are supposed to be deleted after a period. These are the common problems I see when someone complains about deleting old backups using amaintenanceplan. |
dumber and simpler than that.
Be sure you enter your extension without the period. e.g. "bak",
not ".bak". Otherwise the file matching rule will never match your
backup files (it is looking for "foo..bak" and not "foo.bak", and the
Maintenance Plan editor will quite happily let you do this.
<smacks forehead>
ouch!
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.