数据库紧急恢复过程（Database emergency recovery process）.doc

数据库紧急恢复过程（Database emergency recovery process） Database emergency recovery process When the database fails, record the current time and follow the steps below to restore it. 1. backup database. Successfully, using backup files to restore the database, turn second steps. Failure, third steps. 2. restore the database (operating on another server) (1) DECLARE, @backup_device, nvarchar (128), @log_backup_device, nvarchar (128) Set @backup_device = NF:\database\myDb.bak Restore database MyDb From disk = @backup_device WITH, REPLACE, file=5 (2) restore to a specific point in time according to the transaction log - first start the transaction log restore based on a full backup point, and pay attention to the [NORECOVERY] parameter RESTORE database (database name) from fully backup device name with, REPLACE, NORECOVERY, MOVEMyDbTOD:\FMyDb_0606.mdf, MOVEFMyDb_LogTOD:\FMyDb_Log_0606.ldf - start transaction logs A. view transaction log points: RESTORE HEADERONLY, from, disk=transaction log backup files, full path, or backup device name B. begins to recover Restore LOG database name, from transaction log backup device name, with FILE=1, NORECOVERY Restore LOG database name, from transaction log backup device name, with FILE=2, NORECOVERY Restore LOG database name, from transaction log backup device name, with FILE=3, NORECOVERY - the last second backup logs Restore LOG database name, from transaction log backup device name, with FILE=4, RECOVERY - last backup log If the execution fails, move to the next step. 3. copy the database mdb, LDF file. Perform net stop MSSqlServer, stop the SQL Server service, copy the database mdb, and LDF files. Successfully copied 2 files, already other file groups, fourth steps. You can only copy MDB files and turn fifth steps. You can only copy LDF files and turn eighth steps. 4. additional databases (database files and log files) CREATE DATABASE [MyDb2] ON (FILENAME = NF:\back\MyDb.mdf) (FILENAME = NF:\back\MyDb_log.ldf) FOR ATTACH If failure oc