How to Automate Disaster Recovery in SQL Server On-Prem | Data Exposed: MVP Edition

Ғылым және технология

Пікірлер: 7

  • @imrankazi658
    @imrankazi6583 жыл бұрын

    Instead of creating all logins, credentials, configuration, we can also restore master database as well.

  • @DB-sf1hy
    @DB-sf1hy Жыл бұрын

    Great session, please invite her again.

  • @Abassman1967
    @Abassman19673 жыл бұрын

    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?

  • @dbatools

    @dbatools

    3 жыл бұрын

    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 🌟

  • @anthonycurreri1543
    @anthonycurreri154311 ай бұрын

    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?

  • @8982601240
    @89826012403 жыл бұрын

    I pretend that didn't happen by hitting clear

Келесі