Can DBATools work with a company the uses a storage manager like Avamar for there on prem databases and intend on using Azure as our DR SQL Server DBMS? What types of backups does DBATools interface with?
Great stuff from Chrissy as always! We are using dbatools modules as part of our offsite DR solution and they have been a huge time saver. One question I have for Chrissy with this process is can the exported files be used to restore to a remote DR instance with a different host/instance name or is the expectation that the SQL instance name will be the same?
Great question, @Abassman1967 ! If your remote server has the same directory structure, the restore scripts will work. If not, it's no problem. Just pipe Get-ChildItem to Restore-DbaDatabase, and the backup chains will be built for you and automatically restored 🌟
Great session, please invite her again.
Instead of creating all logins, credentials, configuration, we can also restore master database as well.
Can DBATools work with a company the uses a storage manager like Avamar for there on prem databases and intend on using Azure as our DR SQL Server DBMS? What types of backups does DBATools interface with?
Great stuff from Chrissy as always! We are using dbatools modules as part of our offsite DR solution and they have been a huge time saver. One question I have for Chrissy with this process is can the exported files be used to restore to a remote DR instance with a different host/instance name or is the expectation that the SQL instance name will be the same?
Great question, @Abassman1967
! If your remote server has the same directory structure, the restore scripts will work. If not, it's no problem. Just pipe Get-ChildItem to Restore-DbaDatabase, and the backup chains will be built for you and automatically restored 🌟
I pretend that didn't happen by hitting clear