+ Reply to Thread
Results 1 to 5 of 5

SQL 2005 Backup Maintainance Plan - Delete Expired Backups?

  1. SQL 2005 Backup Maintainance Plan - Delete Expired Backups?

    Hi

    We have just upgraded our server to SQL Server 2005 Standard, but our new
    backup maintainance plan is configured for the backups to expire after 5
    days but does not delete them.

    Do I have to setup anything else?

    Thanks
    B



  2. Re: SQL 2005 Backup Maintainance Plan - Delete Expired Backups?

    Expiring is not the same as deleting. Did you build these MP's from scratch
    in 2005 or are they upgraded from 2000?

    --
    Andrew J. Kelly SQL MVP

    "Simon" wrote in message
    news:OlKEmTo1HHA.536@TK2MSFTNGP06.phx.gbl...
    > Hi
    >
    > We have just upgraded our server to SQL Server 2005 Standard, but our new
    > backup maintainance plan is configured for the backups to expire after 5
    > days but does not delete them.
    >
    > Do I have to setup anything else?
    >
    > Thanks
    > B
    >




  3. Re: SQL 2005 Backup Maintainance Plan - Delete Expired Backups?

    Hi

    Thanks for your post.

    Yes we built them from scratch.

    Thanks
    B

    "Andrew J. Kelly" wrote in message
    news:%23Achf0p1HHA.3788@TK2MSFTNGP02.phx.gbl...
    > Expiring is not the same as deleting. Did you build these MP's from
    > scratch in 2005 or are they upgraded from 2000?
    >
    > --
    > Andrew J. Kelly SQL MVP
    >
    > "Simon" wrote in message
    > news:OlKEmTo1HHA.536@TK2MSFTNGP06.phx.gbl...
    >> Hi
    >>
    >> We have just upgraded our server to SQL Server 2005 Standard, but our new
    >> backup maintainance plan is configured for the backups to expire after 5
    >> days but does not delete them.
    >>
    >> Do I have to setup anything else?
    >>
    >> Thanks
    >> B
    >>

    >
    >




  4. Re: SQL 2005 Backup Maintainance Plan - Delete Expired Backups?

    What was your response to my statement that Expire is not the same as
    delete? Did you use the Maintenance Cleanup task to delete the files or did
    you simply set them to expire? If the latter that will not delete files,
    only the cleanup task will.

    --
    Andrew J. Kelly SQL MVP

    "Simon" wrote in message
    news:uo83qC41HHA.5160@TK2MSFTNGP05.phx.gbl...
    > Hi
    >
    > Thanks for your post.
    >
    > Yes we built them from scratch.
    >
    > Thanks
    > B
    >
    > "Andrew J. Kelly" wrote in message
    > news:%23Achf0p1HHA.3788@TK2MSFTNGP02.phx.gbl...
    >> Expiring is not the same as deleting. Did you build these MP's from
    >> scratch in 2005 or are they upgraded from 2000?
    >>
    >> --
    >> Andrew J. Kelly SQL MVP
    >>
    >> "Simon" wrote in message
    >> news:OlKEmTo1HHA.536@TK2MSFTNGP06.phx.gbl...
    >>> Hi
    >>>
    >>> We have just upgraded our server to SQL Server 2005 Standard, but our
    >>> new backup maintainance plan is configured for the backups to expire
    >>> after 5 days but does not delete them.
    >>>
    >>> Do I have to setup anything else?
    >>>
    >>> Thanks
    >>> B
    >>>

    >>
    >>

    >
    >




  5. Re: SQL 2005 Backup Maintainance Plan - Delete Expired Backups?

    Thanks for your post.... I have re-created the maintainance cleanup job and
    we are away.

    Thanks again
    B



    "Andrew J. Kelly" wrote in message
    news:O4am9941HHA.4004@TK2MSFTNGP05.phx.gbl...
    > What was your response to my statement that Expire is not the same as
    > delete? Did you use the Maintenance Cleanup task to delete the files or
    > did you simply set them to expire? If the latter that will not delete
    > files, only the cleanup task will.
    >
    > --
    > Andrew J. Kelly SQL MVP
    >
    > "Simon" wrote in message
    > news:uo83qC41HHA.5160@TK2MSFTNGP05.phx.gbl...
    >> Hi
    >>
    >> Thanks for your post.
    >>
    >> Yes we built them from scratch.
    >>
    >> Thanks
    >> B
    >>
    >> "Andrew J. Kelly" wrote in message
    >> news:%23Achf0p1HHA.3788@TK2MSFTNGP02.phx.gbl...
    >>> Expiring is not the same as deleting. Did you build these MP's from
    >>> scratch in 2005 or are they upgraded from 2000?
    >>>
    >>> --
    >>> Andrew J. Kelly SQL MVP
    >>>
    >>> "Simon" wrote in message
    >>> news:OlKEmTo1HHA.536@TK2MSFTNGP06.phx.gbl...
    >>>> Hi
    >>>>
    >>>> We have just upgraded our server to SQL Server 2005 Standard, but our
    >>>> new backup maintainance plan is configured for the backups to expire
    >>>> after 5 days but does not delete them.
    >>>>
    >>>> Do I have to setup anything else?
    >>>>
    >>>> Thanks
    >>>> B
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >




+ Reply to Thread