SQL Server Rights Management and backup instances

Permission settings:

1, create the user Zhangsan, and give Zhangsan have dbcreator server permissions.

2. Log in using Zhangsan to test if you can create a database.

3. Use the SA user to attach the MySchool database and set Zhangsan to execute the SELECT statement to query the table data in the database. and set the Zhangsan user to be able to delete data from the student table.

4. Use Zhangsan login to test permissions.

Backup and Restore:

1. Verify point-in-time restore (full backup + transaction log backup)

Idea: Create a database Benet, and then create a table stu. Do a full backup first, then write the data to the file, write one line at a time, and then do a thing log backup to restore to a certain point.

2. Tail Backup

Idea: Build a database ACCP, and then create a Stu table. Make a full backup first, then write the data to the file, but do not back up, then stop the SQL Server service, stop and delete the Accp.mdf master database file, open the service, make a tail backup, and restore (the data that was not backed up back).

3. Create a database maintenance plan a full backup of the BDQN database every Sunday 22:00, and a transaction log backup of the database every day from 12:00 and 18:00. Modify the system time to verify the backup effect.

First, permission settings:

1, create the user Zhangsan, and give Zhangsan have dbcreator server permissions.

2. Log in using Zhangsan to test if you can create a database.

3. Use the SA user to attach the MySchool database and set Zhangsan to execute the SELECT statement to query the table data in the database. and set the Zhangsan user to be able to delete data from the student table.

4. Use Zhangsan login to test permissions.

Second, backup and restore:

1. Verify point-in-time restore (full backup + transaction log backup)

Idea: Create a database Benet, and then create a table stu. Do a full backup first, then write the data to the file, write one line at a time, and then do a thing log backup to restore to a certain point.

2. Tail Backup

Idea: Build a database ACCP, and then create a Stu table. Make a full backup first, then write the data to the file, but do not back up, then stop the SQL Server service, stop and delete the Accp.mdf master database file, open the service, make a tail backup, and restore (the data that was not backed up back).

3. Create a database maintenance plan a full backup of the BDQN database every Sunday 22:00, and a transaction log backup of the database every day from 12:00 and 18:00. Modify the system time to verify the backup effect.

Article reference public number: L Baby talk IIT

SQL Server Rights Management and backup instances