search

microsoft / sqlworkshops-sql2022workshop

A workshop to learn about SQL Server 2022
MIT License
194 stars 80 forks source link

Non-Distinct File Names in WWI Backups #35

Closed dbo-Josh closed 1 year ago

dbo-Josh commented 1 year ago

Not all of the included wwi backups have unique filenames, preventing all 3 from being restored at the same time. Adjusting the filenames to be unique would make things easier for users to set up.

rgward commented 1 year ago

Thanks for this feedback. We have a big workshop coming in March so I'm going to defer making changes here until after that. I do want to change it so you can do this.

rgward commented 1 year ago

I've decided to leave everything "as is". Each exercise includes a restore script that removes an existing database of the same name. I also included in the prereqs a statement that you will restore each backup in each exercise instead of all of them upfront.