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 ***

No comments:

Post a Comment