Shulou(Shulou.com)05/31 Report--

MSSQL2005 data additional failure report error 3456 solution, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Solution:

1. Create a new database with the same name (the data file should be the same as the original)

two。 Stop sql server again (be careful not to detach the database)

3. Overwrite the new database with the data file of the original database

4. Restart sql server

5. At this point, there will be a doubt when you open the enterprise manager, forget it, execute the following statement (pay attention to changing the database name)

6. After completion, you can generally access the data in the database, at this time, the database itself is generally a problem, the solution is to use the database script to create a new database, and import the data into the line.

The code is as follows:

USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES'

1 RECONFIGURE WITH OVERRIDE GO UPDATE SYSDATABASES SET STATUS = 32768 WHERE NAME = 'doubtful database name' Go sp_dboption 'questionable database name'

'single user',' true' Go DBCC CHECKDB ('doubtful database name') Go update sysdatabases set status = 28 where name = 'questionable database name' Go sp_configure 'allow updates'

0 reconfigure with override Go sp_dboption 'doubtful database name'

'single user', 'false' Go

An error occurred after executing the above statement: the configuration option 'allow updates' has been changed from 0 to 1. Please run the RECONFIGURE statement to install.

(the number of rows affected is 1 row) Server: message 5105, level 16, status 4, line 1 device activation error. The physical file name'e:\ Program Files\ Microsoft SQL Server\ MSSQL\ data\ bserp_Data.MDF' may be incorrect. The sp_dboption command failed. Server: message 8966, level 16, status 1, line 1 failed to read and latch the page (97purl 6553715) (with latch type SH). Sysobjects failed. DBCC execution completed.

If DBCC outputs an error message, contact your system administrator. (1 row affected) the configuration option 'allow updates'' has been changed from 1 to 0. Please run the RECONFIGURE statement to install

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.