| Author |
Topic |
|
nasu
Yak Posting Veteran
50 Posts |
 Posted - 2008-03-25 : 06:03:35
|
| I have a problem with deleting old bak files from a Cleanup Maintenance Task. I have backups in subdirectories and I read in SQL Server 2005 Books Online that: In contrast to earlier versions of the Maintenance Cleanup task, the SQL Server 2005 version of the task does not automatically delete files in the subdirectories of the specified directory. This constraint reduces the surface area of any attack that could exploit the functionality of the Maintenance Cleanup task to delete files maliciously. To delete the first-level subfolders, you must explicitly elect to do this by checking the Include first-level subfolders option in the Maintenance Cleanup Task dialog box.I cannot find such an option in my Maintenance Cleanup Task dialog box. I do not think I installed any service packs yet, could this be the problem? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-25 : 07:20:12
|
| It is a checkbox under the file extension about halfway down the pop-up.I would say install the service packs as there were quite a few issues with the original release. |
 |
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-03-25 : 20:02:27
|
| I still see no checkbox. There is a textbox where I can enter the file extension of files to delete. Is that the "file extension" you mean? What do you mean by "pop-up"? Maybe this is because of missing service packs after all. I will consider installing them. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 23:12:44
|
| Checkbox is there even you didn't apply any sp. |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-03-26 : 03:44:47
|
| Good to know for starters. Now I only need to find it. Are we all talking about the dialog that opens up if I double-click my Maintenance Cleanup Task in the design view of my maintenance plan? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-26 : 22:52:12
|
| Yes, it's right under file extension. |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-03-27 : 04:40:06
|
| No, under the "File Extension" textbox are the "File Age" settings. I wish I could attach a picture of my dialog. Any ideas why i cannot see this checkbox? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 23:14:27
|
| Do you use ssms or ssmse? |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-03-31 : 02:58:58
|
| I guess you mean SQL Server Management Studio Standard or Enterprise? We installed SQL Server 2005 Standard. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 22:43:25
|
| What's version nuber of SQL Server Management Studio? By the way, ssmse is SQL Server Management Studio Express. |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-04-01 : 21:20:35
|
| The version is 9.00.1399.00. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-01 : 23:08:34
|
| Do you have other machine with ssms? Double check there if so. |
|
|
|
thomasv
Starting Member
2 Posts |
Posted - 2008-04-21 : 11:34:56
|
| hi! I have the same problem as the original post. I have Enterprise ed w/ SP2 (9.00.3042) using ssms. I can not see the little check box "Include first-level subfolders" option in the Maintenance Cleanup Task dialog box either. |
|
|
|
thomasv
Starting Member
2 Posts |
Posted - 2008-04-21 : 12:05:04
|
| nasu et al,run ssms on your local server box, the check box will be there.Apparently, using smss to connect to a remote database is not the same as using it on the local box. Even the icons are a bit different. |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-04-21 : 14:07:29
|
| I have been running ssms on the local server all the time but still no checkbox. I am using Remote Desktop Connection but that should not make any difference, should it? For now, I have scheduled a VBScript to remove old backups since I needed that functionality anyway for other files. Thanks anyway, everyone. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-21 : 22:58:28
|
| SSMS has different versions, should use one that matches sql engine version build. |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-04-22 : 01:52:05
|
| I installed everything from the same disc. I hope this means things should match. |
|
|
|
ocarmona
Starting Member
1 Post |
Posted - 2008-10-31 : 13:41:28
|
| nasu, did you ever figure this out??? anybody here? I got exactly the same version and same problem....I don't see any checkbox!!! |
|
|
|
nasu
Yak Posting Veteran
50 Posts |
Posted - 2008-10-31 : 17:21:45
|
| I still do not know why we do not see this checkbox on our Windows 2000 Server production environment machine. Our IT department recently installed the same version of SQL Server 2005 on two experiment Windows 2003 Server machines. The checkbox is visible on both machines. |
|
|
|
mfinney
Starting Member
2 Posts |
Posted - 2008-11-24 : 11:33:06
|
quote:
Originally posted by ocarmona
nasu, did you ever figure this out??? anybody here? I got exactly the same version and same problem....I don't see any checkbox!!!
|
|
|
|
mfinney
Starting Member
2 Posts |
Posted - 2008-11-24 : 11:33:19
|
quote:
Originally posted by ocarmona
nasu, did you ever figure this out??? anybody here? I got exactly the same version and same problem....I don't see any checkbox!!!
|
|
|
|
Next Page
|
Missing Option in Maintenance Cleanup Task