SQL Server Database Restore

1. Log in to the database with SA identity or Windows authentication

2. Right click databases Select New Database

3. Fill in the database name, select the path (not the default address) for databases files;

Choose option to select the recovery model as simple (default to full, select simple to save server space)

Click OK

4. Right click on new database, select Tasks, select Restore,

5.Source for database selected from device, select. bak file

Option Overwrite (Note: If you cannot find the newly created database file at restore time, you will be careful to recover from a database with the same name as the Bak file)

Click OK

6. Click Server Roles, right-click Logins, select New Login

7. Right click on new logins Select Properties, click User Mapping, select database, tick the db_owner (no other computer can access the database)

Click General to select the default database as the newly created (no data will be found when Mygeneration is not selected)

SQL Server Database Restore