ssms_notes []

This is an old revision of the document!

Download AdventureWorks2019.bak from https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2019.bak
- For other versions see https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
Put the file in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Backup
To install start SSMS → object explorer → Databases → right click → “Restore Database…” → Device → … → Backup media type: → choose “File” → Add → Choose the .bak file → OK → OK
For other users to access it
- SSMS → Object explorer → Security → Logins → DESKTOP-CRLPVE5\<username> → double click → Server Roles → check “public” and “sysadmin”