October 15, 2010 at 2:26 am
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;-)
October 16, 2010 at 1:06 pm
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
---------------------------------------------------------------------
October 19, 2010 at 7:36 pm
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