SQL SERVER2008 Database Common sense

How to connect to a database:

1 . SQL SERVER authentication method: You need to enter a user name and password verification to connect to the database.

2 ,Windows authentication method, click Connect, direct access to the database.

2.How to modify the user name and password on the Microsoft SQL SERVER2008 database:

Open Database ------ -- Click to open the Security folder;

Click the login folder ------ Find the user name of all the databases in your database (I use SA on my Computer ), then right-click ----- Property, modify the user name and password on the popup page.

3.Microsoft SQL SERVER database backup:

tap the database you want to back up ----- right-click the task ----- Click Backup:

Click on the backup popup interface -- --- added,

Select Backup Destination ---- Select the path to the backed up database, and then click OK:

Back to the Backup Database popup box interface, the original path to delete, click OK;

then to the option -à Select Overwrite all existing backup sets ---- Return to general, click OK, Backup succeeded.

4.Microsoft SQL SERVER database restore:

Click on the database you want to restore, the right mouse button task ---- restore ---- database, under General

Select the source device ---- Select the specified backup path to add;

Select the backup path, and the file name to be backed up , click OK:

Click OK

Click on the option to overwrite the existing database;

To modify a path:

Return to the general, click OK, if a backup error occurs, the database is currently being used, you need to connect to the database, the secondary operation of the backup process.

Microsoft SQL SERVER database scheduled backup operation:

5.Click Manage --- Maintenance plan, right click,

Select the Maintenance Plan Wizard:

Click Next , go to change;

Click OK,

After selecting maintenance tasks, continue to click Next;

Select Maintenance Task Order (the order is freely selectable), continue to click Next;

Define the database integrity, select the database you need to backup regularly, click OK;

SQL SERVER2008 Database Common sense