SQL Server database file Recovery Technology
Yzhshi (yzhshi@etang.com)
There are two ways to back up SQL Server databases: one is to back up database files using backup database, and the other isDirectly copy the MDF and log files of the database.The following describes the backup and recovery of the latter. This document assumes that you are familiar with SQL S
=%backpath_full%. DMP SET backpath= SET backpath_full= EXITRecommendation IV:RMAN target=rman/[email protected] Recommendation Five: Edit the cmd command in the text. Then save it as a bat file. When you define a task schedule in Windows, you It can be executed automatically. Cases: Edit a text file Del c:\exp\*.dmp Exp userid=cw/[email protected] file= ' c:\
]
parameters
Description
-0123456789
the level of backup, 0 means all backups, others represent incremental backups, for the last lower level, Back up the file system only modified or new file default 9
-D
Set the density unit of the tape to BPI
-j
Compress write, speci
Tags: Oracle data file recover State recovery process
Querying data File status firstSelect name,status,file# from V$datafile;
2. Close the database and stop monitoringShutdown immediate;3. Open the DatabaseStartup4. Take the Recover status database offline 15 for the data
itHead File name | Tail file nameView file header or end of fileAdd-n parameter to view the file header n rows or the reciprocal n rowsTo view a row of a file individually, you can use the channelExample: View line 3rd of the A.txt fileHead-3 A.txt | Tail-11.4 Combat: Backu
1 HD movie format before and after the file system is one of the Ntfs/exfat/fat32, and the format of the HD movie file size and location has not changed.
2 If the file system is one of the Ntfs/exfat/fat32 before the HD movie file, but the formatted partition has changed, please select "Partition Restore"
3 If the
1, first press the power button to boot, when the screen appears computer logo, please click on the keyboard F9 keys (different brand keys are different);
2. During Windows Recovery, the system automatically loads the recovery file, or chooses Windows Setup[ems Enabled, presses ENTER, then selects the language version of the
MongoDB data file backup and recovery backup and recovery data are important for managing any data storage system. 1, cold backup and recovery-Create a copy of the data file (if you want to stop the MongoDB server), that is, direct copy MongoDB will store all the data in the
SQL Server supports two backup methods: one is to use backup database to back up database files, and the other is to directly copy database files MDF and log files LDF. This article describes the backup and recovery of the latter. This article assumes that you are skilled in using the Server Enterprise Manager and SQL Server Query analyzer)
1. Normal backup and recovery methods
Normally, we need to back u
Step 1th, open the Quick data Recovery software, and click the Data Recovery button to go to the next step.
Step 2nd, click Select Data Recovery mode Remove recovery, and then click Next.
Step 3rd, select the partition where you want to delete the file, we choose C, an
Label:1 Environment PreparationMake a full backup of the database:Verify the current backup file:2 Recovery of database corruption2.1 Impersonation Database corruptionTry restarting the database to see the error:The important point here is that we use the Catlog database as the directory database, so even if the control file is lost it does not affect our recover
In Vim, the file recovery operation may not be performed using Vim in Linux many times, but some people do not know that Vim still has the file recovery function after an abnormal power failure. (Vim, you can also understand Vi. Vi on many machines is equivalent to Vim. you can use the alias command to view details. if
What to do if file recovery mistakenly deletes files
As long as the people who use the computer for a long time, know that mistakenly deleted files are almost inevitable, so the prevention of computer data mistakenly deleted also become very important. Here you can refer to the safety net small share of the following three ways to reduce the occurrence of data mistakenly deleted.
1, after the important da
be incorrect.You have created a project named
'
C: \ Program Files \ Microsoft SQL Server \ MSSQL \ data \ test_log.ldf
'
.However, if your database files are copied from other computers, the above method may not work. You may get an error message similar to the following.Server: Message
1813
, Level
16
, Status
2
, Line
1
Failed to open new database
'
Test
'
.
Create
Database
Will be terminated.Device activation error. Physical
On the Linux-character interface, avoid accidental file deletion and establish a resource recovery mechanism-Linux general technology-Linux programming and kernel information. For details, see the following. Files are deleted in reverse mode to avoid deleting files and rescue deleted files in ext2 File System
Avoid accidental deletion of files and create a resou
=
I installed the composite authentication mode, the SQL Server system administrator account is the Administrators group, the SA password is 123456. And on a default instance: MSSQLServer.So at the command line, execute the following command:
Copy Code code as follows:
setup/action=rebuilddatabase/quiet/instancename=mssqlserver/sqlsysadminaccounts=administrators/sapwd=123456
Step three: do not have any prompt information (whether successful or not) after execution, but yo
, enter Y at the prompt that appears[Email protected] data]# mount-o loop/data/data-disk/ixdba///Mount[[email protected] data]# cp/etc/host*/ixdba///Go inside and put the file[Email protected] data]# cp/etc/passwd/ixdba/[Email protected] data]# cd/ixdba/[[email protected] data]# RM-RF *//Create delete action[Email protected] data]# cd/data/[[Email protected]]# ext3grep/data/data-disk--ls--inode 2//view lost files[[Email protected]]# ext3grep/data/data
Any database may have certain security risks during its long-term use. For database administrators, a complete set of database backup and recovery mechanisms should not only be intended for the secure operation of computer operating systems. When the database fails, you want to re-establish a complete database, which is called database recovery. The restoration subsystem is an important part of the database
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.