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