Post reply

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

  • April 4, 2018 at 8:40 am

    #403226

    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

  • April 4, 2018 at 12:27 pm

    #1985536

    Could you restate your question. I'm not sure what you mean by multiple backup files with unique name.

  • April 25, 2018 at 6:20 am

    #1988166

    Joe Torre - Wednesday, April 4, 2018 12:27 PM

    Could you restate your question. I'm not sure what you mean by multiple backup files with unique name.

    Hi Joe,

    I have schedule Database backup of SQL server DB, backup happens in multiple files. I was the backup file name should be unique with date and time values dynamically set.

    Thanks & Regards

  • April 25, 2018 at 7:23 am

    #1988168

    So the next question would be, what have you tried so far?

  • April 25, 2018 at 7:57 am

    #1988181

    santosh.mane - Wednesday, April 25, 2018 6:20 AM

    Joe Torre - Wednesday, April 4, 2018 12:27 PM

    Could you restate your question. I'm not sure what you mean by multiple backup files with unique name.

    Hi Joe,

    I have schedule Database backup of SQL server DB, backup happens in multiple files. I was the backup file name should be unique with date and time values dynamically set.

    Thanks & Regards

    What are the names of the backup files that you create currently? Do you know how these filenames are generated? Can you expand this peace of code (or whatever is used to generate the names) with a GETDATE() statement?
    And what do you mean with the phrase "using Management" in your initial post?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • 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

Viewing 6 posts - 1 through 5 (of 5 total)

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