Post reply

Sequential Backups

  • January 13, 2003 at 11:43 am

    #79980

    How can you get SQL Server 2000 to back up a complete database daily with a sequential backup name such as Contacts_2003_01_12, Contacts_2003_01_13, etc.?

  • January 13, 2003 at 12:03 pm

    #446195

    Use maintenance wizard to generate backup job which will place the date in your database backup file name, even though it is not exactly same as your format. Or write your one script to do it.

  • January 13, 2003 at 1:37 pm

    #446211

    Thanks. That worked

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

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