• Honestly, download Ola Hallengren's scripts and use them. https://ola.hallengren.com/

    The default structure is Server Name\Instance Name(if needed)\Database Name\Type(Full, diff, or log)

    The one thing within the maintenance plans that seems to be difficult to manage is deleting old files.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/