Restore a Sample database to test AlwaysON

This workshop includes a sample database backup file to test AlwaysON Availability group creation and functionality

  1. Go back to the jumpserver, then open up SQL Server Management Studio (SSMS), then connect to EC2SQL1:

  2. Right-click Databases, then click on Restore Database…:

  3. Click on Device -> Add -> put \\ec2jump\binaries in the File location -> select sampledb.bak, then click OK on all the succeeding prompts, until the SampleDB database has been successufully restored: