Backup Stripping

  • Hi

    i am using sql 2005, we are not using any third party tool for backup.

    I need to take backup in multiple file (separate disk) to reduce IO usage and space usage on particular disk.

    but i haven't got any fruitful doc/article anywhere.

    Few question :

    What are the areas/points we need to keep in mind?

    Can we use to backup striping on data file level ?

    We have backup size of about 5-600 gb so it takes around 6-7 hours. can backup striping help here ?

    Any related discussion/doc/article will be appreciated ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • striping will reduce your backup times. You can do individual file or filegroup backups (see books online). If you switch to using these ensure your complete backup strategy means you can recover your database.

    I suggest just striping though - a google of 'striping backups' gave this (amongst others)

    http://www.mssqltips.com/tip.asp?tip=1941

    ---------------------------------------------------------------------

  • Here's something I wrote some time back on improving backup speed: Speeding up backups

    Hope this helps some.

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

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