Install-DbaMaintenanceSolution,dbatools

The below cmdlet Install-DBAMaintenanceSolution will Ola Hallengren Maintenance soluction for SQLServer databases. -AutoScheduleJobs WeeklyFull parameter will schedule Fully backps weekly once, DIFF backp on Daily and Log backup every 15 minutes.
Install-DbaMaintenanceSolution `
-SqlInstance "RAMESH\UAT" `
-Database DBAMainteance `
-BackupLocation D:\Maintenance\Backup `
-Verbose `
-CleanupTime 72 `
-ReplaceExisting `
-InstallJobs `
-OutputFileDirectory D:\Maintenance\Output `
-AutoScheduleJobs WeeklyFull

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server