selectstarfromyogi

sql server DBA ,sql server 2008 , 2012 , 2014 ,sql

Menu
Search
Skip to content
  • Home
  • About

striping backups

How to stripe SQL Server database backups Using Ola Hallengren’s DatabaseBackup procedure

with the @NumberOfFiles option you can stripe the SQL server Database backups upto 64.

EXECUTE dbo.DatabaseBackup

@Databases = ‘Adventureworks’,

@Directory = ‘E:\Backup\DBBackups\’,

@BackupType = ‘FULL‘,

@Compress = ‘Y‘,

@NumberOfFiles = 8

January 22, 2021yogigollapudi Ola Hallengren, SQL Server, striping, striping backups Leave a comment

Categories

  • DEVOps (1)
  • Errors (9)
  • FUN (1)
  • Performance Tuning (11)
  • powershell (12)
  • T-SQL (43)
  • Uncategorized (154)

Blog Stats

  • 39,568 hits
Follow selectstarfromyogi on WordPress.com
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • selectstarfromyogi
    • Already have a WordPress.com account? Log in now.
    • selectstarfromyogi
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Design a site like this with WordPress.com
Get started