Home Forums SQL Server 2008 SQL Server Newbies Backup databases depending on the size to multiple files RE: Backup databases depending on the size to multiple files

  • March 19, 2013 at 7:55 am

    #1598434

    Alan,

    Sorry for the late response. I tested the script and it works great. But I want to split the backup files to multiple files if the database size is > 50 GB. For example like this:

    tes_20130319_1.bak

    tes_20130319_2.bak

    tes_20130319_3.bak

    tes_20130319_4.bak

    tes_20130319_5.bak

    currently the script backsup the database(s) to single .bak file.

    Thanks