Update from Ola Hallengren: Target multiple devices during SQL Server backup

Posted by Greg Low on SQL Blog See other posts from SQL Blog or by Greg Low
Published on Mon, 17 Sep 2012 00:04:00 GMT Indexed on 2012/09/17 3:46 UTC
Read the original article Hit count: 320

Filed under:

Ola has produced another update of his database management scripts. If you haven't taken a look at them, you should. At the very least, they'll give you good ideas about what to implement and how others have done so. The latest update allows targeting multiple devices during backup. This is available in native SQL Server backup and can be helpful with very large databases. Ola's scripts now support it as well.

Details are here:

http://ola.hallengren.com/sql-server-backup.html

http://ola.hallengren.com/versions.html

The following example shows it backing up to 4 files on 4 drives, one file on each drive:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup, D:\Backup, E:\Backup, F:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@NumberOfFiles = 4

And this example shows backing up to 16 files on 4 drives, 4 files on each drive:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup, D:\Backup, E:\Backup, F:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@NumberOfFiles = 16

Ola mentioned that you can now back up to up to 64 drives.


 

© SQL Blog or respective owner