December 29, 2008 at 3:35 pm
hi
when i am making new maintenance plan then specify in backup option ( remove older files days are not shown)..
so any body please help me ....
December 29, 2008 at 3:41 pm
What is the error you are getting?
What are the steps you have taken to this point?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 29, 2008 at 3:45 pm
You can attach a screen shot using the Post options below as well.
December 29, 2008 at 3:53 pm
Hi Jack
first i select databases which i need to be take backup
2) click on next,next,next, come in Specify Backup Disk Directory.
in this i set the path where i have to take the backup.
but when i select remove files older than
a) i cannot set the day, because day,weeks,hours like option are not shown.
can u please help me out ....
December 29, 2008 at 4:21 pm
I still need more information.
Where are you starting?
What are you selecting at each step?
What type of Maintenance plan object are you dealing with when it fails?
Are you actually getting an error? If so what is the error?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 29, 2008 at 4:28 pm
i am using following steps...
1) ight click on db maintenance plan and select new maintenance plan..
2) after that i select the db's
3)then i click next,next...
4) in specify disk backup directory , in remove files older than ( days) are not showing....
December 29, 2008 at 4:30 pm
error is that the database backup is not schedule through the maintenance plan...
December 30, 2008 at 12:53 am
then i click next,next...
4) in specify disk backup directory , in remove files older than ( days) are not showing....
I think you are confusing the SQL Server 2005 UI with 2000.
In 2005 the UI is different from 2000.
You have to drag and drop "Maintenance Cleanup Task". It has option to delete older files.
Schedule is on the top.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply