Position:home>Technology exchange> A few kinds back up and restore a method what use database of Wu of Zhang of fri
A few kinds back up and restore a method what use database of Wu of Zhang of fri
From;  Author:Stand originally
Means of settlement:



One, backup method:



① makes backup from systematic government, include the backup of the backup that account covers and year account book, this kind of advantage of the portion is simple, yi Cao is made, constrictive good, take up hard disk space is little, but rate is slow, and if be software,the circumstance of occurrence breakdown falls, the likelihood cannot enter systematic government.
② does the backup of the database from Enterprise Manager. Every database has an alone backup. The advantage of this kind of backup is backup speed fast, if have certain knowledge to Sql Server, also be very simple.
③ if if Sql Server cannot be started, two kinds of afore-mentioned methods are invalid, can use the method of duplicate physics file only, the Ufdata.mdf Ufdata.ldf that user account covers and Ufsystem.mdf and Ufsystem.ldf



2, restore a method:



If ① has the word of the backup that account covers, the account in government of direct use system is covered it is OK to introduce a function. Below this kind of circumstance, the attributive information of a few operator is OK and missing, can gift afresh attributive, satisfying also extensive recovers from an illness the Ufsystem system that come controls a library
If ② is the backup of year account book, and there still is this account in software cover the word with year, can cover a director to register with account, fall from menu of year account book next introduce; If be to do not have this account to cover existence, be about to build a credit in systematic government, when establishing account, should notice to enable property of date, industry, account to cover a person in charge only can, other all but oversight, the Ufuncomp.exe that issues the Ufdata.ba_ in backup with App catalog next compresses its solution it is this file again for Ufdata.bak in Enterprise Manager Restore can
The with year account book backup of the backup of the individual database that ③ does through Enterprise Manager can be operated through Restore Database function, particular procedure is right key — of reductive database of — of all task of this database — adds — to browse this file — to decide from — of disk of — of equipment — choice device, enforce ‘ in option label reductive ’ is chosen on, move the catalog that the physical file name that come covers for be in debt and file name. Can restore normally next.
If ④ is the sentence that reinstates from the backup information of other database, can choose reductive from the database, handle the backup information that searchs this database and database in parameter next. Enforce ‘ in option label reductive ’ is chosen on, move the catalog that the physical file name that come covers for be in debt and file name. Can restore normally next.
If ⑤ is the backup that account covers, and be in debt is covered include a lot of year again, can compress this file solution first, find this backup document through what methodological ③ narrates next (backup equipment) , examine the content of this equipment, the backup name that the choice wants to restore database correspondence (every year a date) , choose in option label restore compulsively, configure proper physical file place
Previous12 Next