Everything about database,how to,example,guide,

A lot of important data information that systematic database saved concerned SQL Server,Of these data missing will bring very serious consequence to the system,So we also must undertake backup to systematic database.Such once system or database fail,Can rebuild through restoring to come systematic database.Important in SQL Server system database basically has Master, Msdb, Distribution, Model.Although Tempdb also is systematic database but not was necessary to undertake backup to its,Because SQL Server is started every time,can found this database afresh,And when SQL Server stops to move,All data in Tempdb database can be kept clear of automatically.Back up and resume an issue what in this section we basically discuss Master database.
Database of backup Master and backup user database are same,Want database condition to produce change only we are about to save these change once the system is broken,stop in case through backup.The happening that be defeated and brings about data to lose the following case often asks we undertake backup to Master database instantly.

Increase or delete user database.But if increase or delete file or file group,Or user database increases the data that will allow take in the fresh-take in new Party members to add automatically,These are operated and do not affect to generation of Master database,Need not undertake backup to its right now so;
Found new entry or carry out with log onto concerned operation,But increase database user not to affect Master database;
Found or delete backup equipment;
Be called to have distributed inquiry or long-range process and undertake configuration to database server,Like increase join server or login remotely etc.
To Master database,We often undertake complete database backs up.And restore Master database,Have two kinds of ways however:Or it is to use Master database to back up currently,Or it is to carry out Rebuild Master Utility to rebuild Master database.If Master database suffers attaint still can't make SQL Server cannot be started,The current backup that we can use Master database will carry out restore;If Master is played havoc with,SQL Server cannot be started,Or the current backup of Master database also cannot be used,We must carry out Rebuild Master Utility to rebuild Master database (right now all previously data in Master database will be lost) ,Next reuse backup will undertake resumptive (if the backup of Master can be used) .
Use Rebuild Master Utility will rebuild Master basically implements the following measure:
(1) put out SQL Server,Run the Rebuildem.exe file that is located in \ Microsoft SQL Server\80\tools\Binn to fall next,Dialog box of occurrence Rebuild Master.The 15-17 that be like a graph is shown.

(2) click Browse pushbutton to scan the source list that includes Data file.
(3) click dialog box of occurrence Collation Setting of Setting pushbutton,The 15-18 that be like a graph is shown.
(4) click Rebuild pushbutton to rebuild Master database.

Rebuild Master database is whole only those who resume the work begin,The backup that should load Master database next.If backup is not usable,The backup facility that should establish any needing to want afresh,Restore database of Msdb Model Distribution and user database then.To those is in for the database that Master database founds after the closest backup,If its are put in backup,Use backup to undertake resumptive,If nonexistent,Can pass document of new link database only (data and log file) will restore a database afresh.
In SQL Server,We can ravel the data file of the database and clerical log file,Receive them another servers repeatedly afresh next or same a server.Ravel the database deletes the database from inside SQL Server namely,But the integrality that holds data and clerical log file.Next clerical log and data file can be on the server of any moving SQL Server be become by new link this database.Because this becomes you to prepare to move the database to another machines from a machine,go up but do not found a database afresh,Perhaps move the database you can discover the fractionation of the database and join are very useful point on another disk.

This chapter brief summary
The relevant issue that this chapter basically discusses to the database backs up and restore.The similarities and differences that should know methods of all sorts of different database backup mainly is nodded,Back up and renew strategy what learn to make phasing answer according to different and actual condition.Know backup equipment found method and how to use SQL Server Enterprise Manager and BACKUP, RESTORE commands backup or restore a database.