March 23, 2009 at 9:31 pm
HI every body,
I created a Maintenence plan so as to take Baku up of a database for every 5 hours yesterday at 1:00 PM , It works finely for 2 backups (ie; at 6:00PM and at 11:00PM) after that there's no back up gets occured.Ithink it was problem in schedule bcoz i kept the ending time as 11:59:59 , One more important thing is that i have to delete the 1 day old backup files from the drive where it was storing.Can anybody help me , its urgent.
Thanks for all.
Venu Gopal.K
Software Engineer
INDIA
March 23, 2009 at 10:26 pm
To clean out old backups you can Implement a new task that cleans backup that are older then 1 day. As for you backup not working are there any errors logged in the Maintenance plan history?
If you schedule to run every 5H from 12:00:00AM to 11:59:59PM, you'll get backups at 5AM, 10AM, 3PM, 8PM, 11PM .. if the 11PM backup is not finished by 12AM come around that backup will not kick off. So check to see if there are errors logged that cause an issue with future executions of backups...
I am curious .. are all these backups full backups?
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 23, 2009 at 10:48 pm
Hi 500,
I donno u r name that u was not quoted u r name an soryy for calling u as 500. CAn u tell me exactly which task i have to add for deleting the 1 day older backup files from the drive where they are stored.Rply fastly .
thanks a lot
Venu Gopal.K
Software Engineer
INDIA
March 23, 2009 at 10:58 pm
You want to use the "Maintenance Cleanup Task" task to clean up old backups.
And ... name is .. Gupta .. Mohit Gupta 😛 Okay doesn't work as well as James Bond LOL. The "Mr or Mrs. 500" is just a err title LOL, name is above that ;-).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 23, 2009 at 11:04 pm
oooh ok
but now i used a History clean up task
What is the main duty of History clean up task and what did it do?
Shall i create a new Maintenance plan and New Maintenence plan Clean up task for deleting the old files and stop the previous one which i used the History clean up task?
tell me what i have to do now for deleting the 1 day older files exactly?
What can i do for the previous one which i created by using History clean up task?
thank u.
Venu Gopal.K
Software Engineer
INDIA
March 23, 2009 at 11:08 pm
oooh ok
but now i used a History clean up task
What is the main duty of History clean up task and what did it do?
Shall i create a new Maintenance plan and New Maintenence plan Clean up task for deleting the old files and stop the previous one which i used the History clean up task?
tell me what i have to do now for deleting the 1 day older files exactly?
What can i do for the previous one which i created by using History clean up task?
thank u.
Venu Gopal.K
Software Engineer
INDIA
March 23, 2009 at 11:11 pm
Go to SSMS.
Connect to your server.
Go to Management.
Go to Maintenance Plans.
Select your plan.
Right click->Design.
In the Design window Drag the "Maintenance Cleanup Task" task in to the window.
Drag the GREEN arrow from your Backup task to the new Cleanup Task you created.
Double click on the "Maintenance Cleanup Task" task ...
- Enter in you backup file extension without the ".", so if it's ".bak", just enter "bak".
- Enter in the path where you are storing your backups.
- Choose the duration of backups (how old they have to be before deleted).
- Click Ok.
Click Save on Maintenance Plan window.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 24, 2009 at 3:53 am
Hi mohit can u explain me what is the exact use of "History clean up task" and where exactly this will be used.
Thanks for u r rply.
Venu Gopal.K
Software Engineer
INDIA
March 24, 2009 at 7:28 am
History Clean up Task is used to clean up history from MSDB. Each time you take a backup a record record can be made to the MSDB history tables for the jobs and the maintenance plan. You can use this to clean out the history so your MSDB doesn't grow to large.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 24, 2009 at 7:44 am
Muhit has said it perfectly. Also if you have any other files in the folder that you want to cleanup, you can use "*" asterick instead of "bak" or "trn" for backup extensions and it will get rid of all the files older than 24 hours, however you have to be careful wtih this as it clears all the files.
Ellie
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply