splitting multiple backups out of single backup file

Question

splitting multiple backups out of single backup file

jertle

Valued Member

Points: 56
More actions
August 4, 2008 at 12:07 pm

#195329

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

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

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

Jayakumar Krishnan SSCarpal Tunnel Points: 4710 More actions · Answer 1

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.

Thanks
Jay
http://www.sqldbops.com

paksyeet SSCommitted Points: 1596 More actions · Answer 2

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

Ray Mond SSCertifiable Points: 7159 More actions · Answer 3

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.