SQL review security and Rights Management +vmware increase HDD capacity

Source: Internet
Author: User
Tags filegroup

Reference: Http://www.cnblogs.com/Jackeyzhang/archive/2011/05/18/2049621.html how VmWare virtual machines increase hard disk capacity

http://blog.csdn.net/superchanon/article/details/8255566 dos switch letter (direct CD not)

?

Reference: http://blog.csdn.net/songyuhongnannan/article/details/7279070 SQL Server role and Rights Management

?

Security of the database:

Physical processing mode and system processing mode. Physical processing to prevent password leaks and so on.

System processing method is to increase the rating settings, to each user different permissions.

?

Rights Management:

Granting permissions through the GRANT command

Statement permissions: Grant CREATE TABLE, create view to Maguser

Object permissions: Grant Select, Insert,update,delete on Mag_info to Maguser grant Select on Dbo.mag_info to accounting with Grant Optio N (user Maguser to grant the accounting role the SELECT permission for table Mag_info)

?

Deny permissions:

Depending on the actual needs, sometimes you need to restrict the permissions of certain users or roles and Deny permissions on the user account.

Statement permissions: Deny CREATE view, create table to Magtwo, Magthree

Object permissions: Deny update, delete on Mag_info to Maguser

?

Revoke permissions:

You can revoke a previously granted or denied permission.

Statement permissions: Revoke CREATE TABLE from Magtwo

Object permissions: Revoke select on Mag_info to Magtwo

?

Backup and recovery of the database:

Backing up and restoring critical data stored in a database provides an important means of protecting data from multiple disasters, such as media failure, unintentional or malicious modification and deletion, and permanent server loss, by developing the right backup strategy.

Develop a backup strategy:

Only fixed server user roles in SQL Server can back up databases, such as members of the Db_backupopoerator, sysadmin, and db_owner databases. Of course, database backup permissions can also be assigned to other users by these roles.

In general, we back up the user database, system database, transaction log and so on.

Backing up and recovering databases:

There are four ways to back up:

Full database backup (entire replication), differential database backup (replication of changed data), transaction log backup (information in the replication transaction log), database file or filegroup backup (database large, copy part of it)

Recovery model:

Simple recovery (one of the top two in the backup method), full recovery (first three), bulk-Logged recovery

?

Database backup:

Example: Create a full database backup and differential database backup, log backup, file backup for the MAGDB database

Backup database docdb to docdb_0 with Init

Backup database docdb to docdb_0 with differential

Backup log magdb to disk = ' xxxxx '

Backup Database magdb file= ' magdb ' to disk = ' xxxx '///The data file Magdb.mdf the DB Magdb is backed up to disk.

?

Database Recovery :

Example: Restoring a full database backup of a database docdb

Restore database docdb from Docdb_0 with NORECOVERY, replace

Recovering a differential database backup of a DOCDB database

Restore database docdb from Docdb_0 with file=2, recovery

Recovery log:

Restore log magdb from disk = ' xxxxx '

Specific file or filegroup recovery:

Restore database magdb file= ' magdb ' from disk = ' xxxxx '

?

SQL review security and Rights Management +vmware increase HDD capacity

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.