Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Backup databases depending on the size to multiple files Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 12:24 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 2:14 PM
Points: 207, Visits: 1,536
The "TO" should only exist on the 1st line.

Backup Database TEST to
disk = '',
disk = '',
Post #1432852
Posted Tuesday, March 19, 2013 12:30 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 6,603, Visits: 14,166
This

BACKUP DATABASE Test1 
TO DISK = 'C:\temp\20130319_1.bak',
TO DISK = 'C:\temp\20130319_2.bak',
TO DISK = 'C:\temp\20130319_3.bak',
TO DISK = 'C:\temp\20130319_4.bak',
TO DISK = 'C:\temp\20130319_5.bak'


Should be this

BACKUP DATABASE Test1 
TO DISK = 'C:\temp\20130319_1.bak',
DISK = 'C:\temp\20130319_2.bak',
DISK = 'C:\temp\20130319_3.bak',
DISK = 'C:\temp\20130319_4.bak',
DISK = 'C:\temp\20130319_5.bak'


The multiple backup devices should ideally be on separate devices, i doubt you'll see any improvements.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1432856
Posted Wednesday, March 20, 2013 3:46 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 12:06 PM
Points: 887, Visits: 2,453
pehlebhiayatha (3/19/2013)
Perry,
Currently we don’t have multiple devices or any third party tools to backup the large databases. I read in article if we strip the backup files to multiple .bak files, we can cut down the backup duration. Currently our backups are taking longer and creating only single .bak file for large database >200 GB

Thanks


Either you missed part of the article, or it was incomplete.

Striping backups to multiple files is only an advantage if each stripe goes on a physically separate set of spindles, and then only if the physical write rate was a nontrivial bottleneck in the first place.

Striping backups to the same set of spindles will only do nothing or slow you down.
Post #1433516
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse