So I’m doing another 31 days of posts, hopefully consecutive days but given current pandemics and sporadic working hours it may not be.
This is the index of all the posts, I’ll update it as each one is posted.
Posts
- Day 1- Introduction to the dbatools Backups and Restore Series
- Day 2 – Backup-DbaDatabase Basics
- Day 3 – Backup-DbaDatabase Filenames and Paths
- Day 4 – Backup Encryption with Backup-DbaDatabase
- Day 5 – Backup Performance Tuning
- Day 6 – Using Backup-DbaDatabase in Scripts
- Day 7 – Backup to Azure with Backup-DbaDatabase
- Day 8 – Why is Restore-DbaDatabase like it is?
- Day 9 – The Limitations of Restore-DbaDatabase
- Day 10 – Simple database restores with Restore-DbaDatabase
- Day 11 – Renaming databases when restoring with Restore-DbaDatabase
- Day 12 – Moving and renaming files with Restore-DbaDatabase
- Day 13 – Restore-DbaDatabase and point in time restores
- Day 14 – Restoring a SQL Server database without recovery
- Day 15 – dbatools and Backup History
- Day 16 – Saving and recreating dbatools BackupHistory
- Day 17 – Restore-DbaDatabase and Azure
- Day 18 – Restore-DbaDatabase and Ola Hallengren’s Maintenance Solution
Garry Bargsley
Updates with new days not showing on this recap page.
Stuart Moore
Sorry about that Garry, life, lockdown and work got in the way. I do meant to come back and finish the series off as soon as I get the time.
Swarn Singh
Very logically lay out series that helps to understand much easier. Thanks for such intelligent works Stuart.
I must share a idea striked in my mind while I was going thru the posts. That is why not a similar series of posts on SQL Server containerization using either dbatools or powershell.
What I mean is… spin up SQL Server on Docker using dbatools or powershell same as on VM or physical server with standard recommended configurations e.g. separate drives for data, log, tempdb and backups and other SQL level configurations, Ola Maintenance plans configurations, persistant data storage etc…
Hope it would be good initiative to work and helps learners.
Regards
Swarn Singh
Stuart Moore
That sounds like a good idea. I’ll add it to the list. Thank you.