splitting multiple backups out of single backup file

  • I inherited a MS-SQL 2000 DB that had daily backups being written to one file, now at 136 GB for a 700 MB DB.

    The company wants to keep all of the backups so to conserve disk space I thought it would be best to split all of the days out to individual backup files and compress them.

    Does anyone have a script or know if it's even possible to automate the splitting out?

    Thanks,

    Jason Lee Ertle

  • I couldnt understand your requirement clearly, do you want to split the SQL native backup for a database into different files, if so below is the example.

    backup database master to DISK ='D:\Test1.bak',

    disk ='D:\Test2.bak' [other required parameters if needed]

    if not, pls give more clarity on this...

    Jay.

  • i think his backup set up is 'append to media'

    and with this he wants to separate each back ups as a single file..

    >>

    i dont think there's a posible way for that..;p

  • I think you'll need to restore each backup set, and then back up the restored database to a unique file. Tedious, but on the bright side, you'll be testing your backups. 🙂

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • it is not possible

  • awe shucks...

    thanks everyone

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

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