SQL Server 1

First, Login server

There are two types of connection servers, one for Windows authentication and one for SQL authentication. The latter requires a user name and password and needs to be created by itself.

Second, create a database

In the left Object Explorer, select the database and right-click the new database, which is:

Third, delete the database

In the left Object Explorer, select the database and right-click Delete, which is:

Iii. Separation of databases

In the left Object Explorer, select the database, right-select the task, and select the Detach command, which is:

Iv. additional databases

In the left Object Explorer, select the database, right-click Attach, i.e.:

V. Backing up the database

1. Select the database you want to back up, right-click the task, select Backup, i.e.:

2. Fill in the Backup Database dialog box, i.e.:

Vi. Restoring the Database

1. Select the to database, right-click Task, select Restore, i.e.:

2. Complete the Restore Database dialog box, which is:

SQL Server 1