Home Forums SQL Server 2012 SQL 2012 - General SQL Server 2012: How to take database full backup with multiple files with Unique file name including date using Management. RE: SQL Server 2012: How to take database full backup with multiple files with Unique file name including date using Management.

  • April 25, 2018 at 10:19 am

    #1988225

    santosh.mane - Wednesday, April 4, 2018 8:40 AM

    Hi,

    I want to take SQL server database full backup with multiple backup files with Unique file name including date using Management.

    Can you please help?

    Thanks & Regards,
    Santosh

    If  you mean using Maintenance Plans in SQL Server Management Studio, you can't do it with unique names with dates for every backup. Striped backups with maintenance plans use static file names or devices.
    You would need to write your own or you can use a couple of the free procedures/scripts available for SQL Server which both support striped backups:
    Minion Backup
    Ola Hallengren

    Sue