Back up the database, and then use the following method:
Copy Code code as follows:
Use MASTER
Go
sp_configure ' ALLOW UPDATES ', 1 reconfigure with OVERRIDE
Go
ALTER DATABASE database_name SET Emergency
Go
sp_dboption ' database_name ', ' Single user ', ' true '
Go
DBCC CHECKDB (' database_name ', ' repair_allow_data_loss ')
Go
ALTER DATABASE
database repair, and so powerful.Second, why choose Darth SQL database repair software (support fragment reorganization, support ransomware virus encryption repair)?Functional characteristics1. The supported
LogWriter log flush (write log) to fail. Failure to write a log can result in data suspect.
2014-03-17 03:15:56.05 spid5s error:17053, Severity:16, State:1.
2014-03-17 03:15:56.05 spid5s logwriter:operating system error1117 (failed to retrieve text for this error. REASON:15105) encountered.
2014-03-17 03:15:56.05 spid5s Write Error during log flush.
2014-03-17 03:15:56.05 spid79 error:9001, severity:21, State:4.
2014-03-17 03:15:56.05 spid79 The
Tags: os ar sp data on art as database sqlWhen working with SQL Server relational databases on a daily basis, there are times when the database (for example, SharePoint site configuration database name Sharepoint_config) is not functioning properly, such as the database stop
', repair_allow_data_loss) command, restart the SQL Server service and continue with the attempt.
9. If the DBCC CHECKDB (' db_name ', repair_allow_data_loss) command fails, go to step 10th, or if the error in the database is successfully repaired:
Re-execute the DBCC CHECKDB (' db_name ') command to confirm that no errors exist in the database.
Clear the
recovery. That is, no log files or log file corruption in the case of recovery2, the SQL Server data file has a bad page in the case of recovery. 3, in SQL Server2000, SqlServer2005, SQL2008 run in simple log mode, full log mode or bulk logging mode data is mistakenly (drop, delete, truncate) Delete table recovery, Data recovery after updata, etc.4. SQL serve fi
name for recovery use (Note: This example is MyDB) with the same name as the problem database.
B Deactivate the database server.
C Delete the log file mydb_log.ldf of the database you just generated (in this case, the name of the column database, actually using your own database
acceptance, feedback data 100% complete, accurate and correct, fast recovery speed, high efficiency, save a lot of hospital losses, customer satisfaction! Get the customer's great praise."Warm tip": This case tells us that the RAID server is not 100% reliable, but still a certain program to reduce the chance of damage. Do not power off the server host, press the restart key to forcibly restart. The circuit is unstable be sure to use the UPS power supply."Data Engineer" Yun Jun telephone//qq:183
Fix the failure of attaching only the mdf file to the databaseThe following error is reported:Server: Message 1813, level 16, status 2, Row 1Failed to open the new database 'test '. Create database will be terminated.Device activation error. The physical file name "d: \ data \ test_log.LDF 'may be incorrect.Steps:A. Use "Enterprise Manager" to create A new data with the same name. You can modify the default
SQL database Repair TechnologyThere are two ways to back up SQL Server databases: one is to back up database files using backup database, and the other is to directly copy the database
department Data type SQL SERVER2000 Web site database Data size 8 GBFault phenomenon C-disk format, System redoCustomer request to restore all basic dataFault detection The customer has backed up the data to D, and the database cannot be restored by using the D-disk database to restore the consistency error. A small n
, overwriting the database data file that you just generated with the database MDF file you are restoring Test_data.mdf.
D. Start the database server. You will see that the state of the database test is suspect. No action can be made on this
The MSSQL compression database tutorial Check backup set Repair Database SQL statement
This tutorial provides an example of an SQL statement that examines the backup set repair database
MS SQL Server provides a number of database repair commands that can be tried when the database is questioned or if a read cannot be completed.1. DBCC CHECKDBAfter restarting the server, execute the following SQL in SQL Query Anal
can select the database server in SQL Server Enterprise Manager, right-click, select Properties, and in the Server Settings page, select the Allow direct modification to system directory. You can also use the following statement to implement. Use Mastergosp_configure "Allow updates", 1goreconfigure with Overridegof. Set test for Emergency Repair mode update sysd
MS SQL Server provides a number of database repair commands that can be tried when the database is questioned or if a read cannot be completed.1. DBCC CHECKDBAfter restarting the server, execute the following SQL in SQL Query Anal
, it is recommended that users do not blindly repeated power to try to avoid deformation of the magnetic head on the disc formation of serious scratches, resulting in irreparable damage. In this case, it is necessary to restore the open data in the clean room, replace a good set of normal working heads or motors to restore the data on the original disk completely. Very high demands on the working environment and the engineer's workmanship. 8. Irresistible damage to strong earthquakes, fires, flo
many repair statements are not universal. This failure is typically caused by System page corruption, and the corrupted table ID is 3. The system table in which the ID3 is located is queried by the statement. Repair the damaged system tables may be rebuilt, re-rebuild the log, DBCC detection after the discovery of the database is normal, and the data in the tabl
found a database on the Internet, in their own SQL Server 2008 R2 restore, there is an error, it seems that the version is different.
The restore was unsuccessful, the database was canceled, but it was in a "suspicious" state and could not be viewed and used.
Some repair operations are also useless.
when the
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.