July 2018
Beginner
552 pages
13h 18m
English
Similar to the SqlServer module command, dbatools also has commands to back up and restore databases. However, it offers a lot more control over the details, and more tooling around backup to supplement them. A few example commands are as follows:
# Backup the databases selectedBackup-DbaDatabase -SqlInstance Server1 -Database HR, Finance# Restore databasesRestore-DbaDatabase -SqlInstance server1\instance1 -Path \\server2\backups# List backup historyGet-DbaBackupHistory -SqlInstance server1# Measure backup throughputMeasure-DbaBackupThroughput -SqlInstance server1
The core feature tool in dbatools relating to backup, however, is the automated backup test command, that enables dbas to verify that their backups actually ...
Read now
Unlock full access