Overwrite option in Maintenence Plan | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Overwrite option in Maintenence Plan

I have created a maintenence plan using SQL Enterprise Manager. But i cannot find any option to set it to overwrite the backup tape. I am looking for this because the maintenence plan will backup my SQL database until the tape full of space and make the plan failed to backup well. Any experts can help me? Thanks.
Instead of maint. plan for backup to tape, use normal BACKUP statement to schedule as defined in SQL Books online and use WITH INIT option to overwrite the current backup. Edit:
Just gone thru BOL and found media retention Option which may be useful in your case to overwrite the backup, refer to books online. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Using EM you have an option: Override Media or Initialize Tape (that will erase tape first).
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
I suppose that option is on the backup devices, but not while using DB Maintenance plan.
(valid addition by Luis) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
use normal BACKUP statement to schedule does not meet my needs because i have to make auto backup on weekdays on 10pm and weekends on 3pm. Moreover, i need to backup transaction log and create result log. So finally, i still force myself to use the Maintenance Plan instead of using manual backup. Any idea to solve it? What should i do?
You can still do all these with regular BACKUP statements by scheduling these as Jobs. and You can create multiple schedules with each job. Unfortunately, maint. plans are not very flexible.
True, I second Chakri’s addition.
Refer to the books online for scheduling the jobs and this linkhttp://databasejournal.com/features/mssql/article.php/3285691 to troubleshoot the jobs. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
How about to create two jobs?. One for Weekdays and other for Weekends.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>