Showing posts with label advantage. Show all posts
Showing posts with label advantage. Show all posts

Sunday, February 12, 2012

Backup in multiple backup files

Hi folks
What are the advantages of specifying more than one backup file in the
backup operation.
One advantage I know is, it can be spread across multiple hard drives if
it is a huge database. Are there any other advantages for doing so.
Thanks in advance.
*** Sent via Developersdex http://www.examnotes.net ***Striping the backup allows SQL to do the backup more quickly... If you place
3 file names in the list, then SQL will divide the db into approximately 3
equal pieces and back each piece up in parallel... More importantly this
allows the restore to occur more quickly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Venkatesan" <nospam_venkat_asp@.yahoo.co.uk> wrote in message
news:Og5bAWPOFHA.1500@.TK2MSFTNGP09.phx.gbl...
> Hi folks
> What are the advantages of specifying more than one backup file in the
> backup operation.
> One advantage I know is, it can be spread across multiple hard drives if
> it is a huge database. Are there any other advantages for doing so.
> Thanks in advance.
> --
> *** Sent via Developersdex http://www.examnotes.net ***