Post reply

Backing Up Via TSQL [Newbie Alert]

  • March 15, 2004 at 8:07 am

    #498771

    The issue is that you are saving all the backups to the same file. SQL Server has to delete all or nothing. So, let's say you have RETAIN 1 day.

    You backed up yesterday to mybackup.bak. Today you backed up to the same file. The file now has today's date, not yesterdays. SQL Server can't delete it.

    Search on this site, especially go to the forum for BACKUPs, and you should find how to save backups to files based on the date.

    -SQLBill

  • March 15, 2004 at 8:28 am

    #498780

    Thanks for that, it explains the problems I've been having.

Viewing 2 posts - 1 through 3 (of 3 total)

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