Post reply

I am configuring the backup of all the databases using Maintenance Plans.

  • July 25, 2011 at 3:34 am

    #1357653

    what do you have set under the option "delete files older than the following'. have you tried running the plan manually or are you waiting for a job to execute the plan ?

    Jayanth Kurup[/url]

  • July 25, 2011 at 3:38 am

    #1357657

    forsqlserver (7/25/2011)

    Yes I have test database for mirroring and test2,test3 database fro logshipping.Now I am applying ir for single database still MNITENANCE CLEANUP TASK is not deleting bak file.

    OK. so these databases will not be read from. So you can skip them. Also, remember that databases involved in mirroring or log shipping are not accessbile so no need to take backup of them. Just concentrate on taking the backup of their principal or primary partners.

    As far as deleting the backups is concerned, make sure that the path you are providing is correct. You should also place a check in the option- 'subfolders' and make sure that when you type the extension of the files, you want to delete, just write 'bak' and not '*.bak'. this portion should be easy to configure. do a search on the same and some website might show you step by step creation by showing images too. Try it on your own first so that you are familiar the areas where tasks usually fails. When you learn something on your own, you get the best learning experience.

    Also, as stated in previous posts, keep you job output handy to read the log.

    Let me know how it works!

  • July 25, 2011 at 5:15 am

    #1357687

    Hi forsqlserver, did the tips from chandan helped you? or do you still have problems, please let us know.



    My blog

  • July 26, 2011 at 7:03 am

    #1358474

    Stop using maintenance plans. They have lots of issues, especially when it comes to indexes/statistics mx. Get the awesome, free and fully documented stuff from ola.hallengren.com

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • July 26, 2011 at 12:04 pm

    #1358716

    TheSQLGuru (7/26/2011)

    Stop using maintenance plans. They have lots of issues, especially when it comes to indexes/statistics mx. Get the awesome, free and fully documented stuff from ola.hallengren.com

    I agree with you Sir.The scripts that you mentioned are truly gems but in the case here, I believe that the guy who asked the original question is new to SQL Server and its tools. Maintenance plans are not that bad:-). But they do have few limitations. However, I still believe that it is a good place to start when someone is new to backups. When he gets used to it, he will figure out its limitations like maintenance plan cannot smartly rebuild or reorganize indexes among many stuffs. Gradually this guy will become a master and will start using scripts for every maintenance tasks.

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply