SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Missing Option in Maintenance Cleanup Task
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 03/25/2008 :  06:03:35  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
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

United Kingdom
3603 Posts

Posted - 03/25/2008 :  07:20:12  Show Profile  Reply with Quote
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.
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 03/25/2008 :  20:02:27  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
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.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/25/2008 :  23:12:44  Show Profile  Reply with Quote
Checkbox is there even you didn't apply any sp.
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 03/26/2008 :  03:44:47  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
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?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/26/2008 :  22:52:12  Show Profile  Reply with Quote
Yes, it's right under file extension.
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 03/27/2008 :  04:40:06  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
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?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/27/2008 :  23:14:27  Show Profile  Reply with Quote
Do you use ssms or ssmse?
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 03/31/2008 :  02:58:58  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
I guess you mean SQL Server Management Studio Standard or Enterprise? We installed SQL Server 2005 Standard.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 03/31/2008 :  22:43:25  Show Profile  Reply with Quote
What's version nuber of SQL Server Management Studio? By the way, ssmse is SQL Server Management Studio Express.

Edited by - rmiao on 03/31/2008 22:44:20
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 04/01/2008 :  21:20:35  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
The version is 9.00.1399.00.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/01/2008 :  23:08:34  Show Profile  Reply with Quote
Do you have other machine with ssms? Double check there if so.
Go to Top of Page

thomasv
Starting Member

2 Posts

Posted - 04/21/2008 :  11:34:56  Show Profile  Reply with Quote
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.
Go to Top of Page

thomasv
Starting Member

2 Posts

Posted - 04/21/2008 :  12:05:04  Show Profile  Reply with Quote
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.
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 04/21/2008 :  14:07:29  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
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.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/21/2008 :  22:58:28  Show Profile  Reply with Quote
SSMS has different versions, should use one that matches sql engine version build.
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 04/22/2008 :  01:52:05  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
I installed everything from the same disc. I hope this means things should match.
Go to Top of Page

ocarmona
Starting Member

1 Posts

Posted - 10/31/2008 :  13:41:28  Show Profile  Reply with Quote
nasu, did you ever figure this out??? anybody here? I got exactly the same version and same problem....

I don't see any checkbox!!!
Go to Top of Page

nasu
Yak Posting Veteran

Sweden
50 Posts

Posted - 10/31/2008 :  17:21:45  Show Profile  Click to see nasu's MSN Messenger address  Reply with Quote
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.

Edited by - nasu on 10/31/2008 17:22:47
Go to Top of Page

mfinney
Starting Member

2 Posts

Posted - 11/24/2008 :  11:33:06  Show Profile  Reply with Quote
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!!!

Go to Top of Page

mfinney
Starting Member

2 Posts

Posted - 11/24/2008 :  11:33:19  Show Profile  Reply with Quote
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!!!

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000