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

This article mainly introduces "how to solve SQL SERVER2012 backup log error reading failure: 23", in daily operation, I believe many people in how to solve SQL SERVER2012 backup log error reading failure: 23 problems have doubts, Xiaobian consulted all kinds of information, sorting out simple and easy to use operation methods, hope to answer "how to solve SQL SERVER2012 backup log error reading failure: 23" doubts help! Next, please follow the small series to learn together!

SQLSERVER2012 Backup log error:"Read failure: 23(Data error (cyclic redundancy check).) "

Problem: SQLSERVER2012 database, August 6 LOG automatic backup problem, before the backup has been normal, the error is as follows:

Failed:(-1073548784) Execute query "BACKUP LOG [chenjchdb] TO DISK = N'E:\\chen_... "Failure,

The error is as follows:"Read failed on 'D:\\chen\\chenjchdb\chenjchdb_log. ldf': 23(data error (cyclic redundancy check).)

Reason:

Automatic and manual backup of log files failed with error Read failure: 23(data error (cyclic redundancy check)

Suspect log file corruption or hard disk failure, check hard disk without alarm, can not determine whether the disk has bad sectors;

Solution:

dbcc checkdb is slower and shrinks log files directly;

1. Full backup of the database during off-peak periods;

2. Change the database recovery mode from full mode to simple mode;

3. shrink journal;

4. Change the database recovery mode from simple mode to full mode;

5.(b) Fully prepare the database;

6. backup database logs;

The process is as follows:

---1 22:10 Database fully prepared

use master

BACKUP DATABASE chenjchdb

TO DISK='E:\chen\chenjchdb_20190806_22_30.bak'

WITH COMPRESSION

GO

---2 shrink log

---SELECT [name] FROM sys.database_files WHERE type_desc='LOG'; --- chenjchdb_log

USE master

GO

ALTER DATABASE chenjchdb SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE chenjchdb SET RECOVERY SIMPLE

GO

USE chenjchdb

GO

DBCC SHRINKFILE (N'chenjchdb_log' , 1, TRUNCATEONLY)

GO

USE master

GO

ALTER DATABASE chenjchdb SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE chenjchdb SET RECOVERY FULL

GO

---3 Database fully prepared

use master

BACKUP DATABASE chenjchdb

TO DISK='E:\chen\chenjchdb_20190806_23_00.bak'

WITH COMPRESSION

GO

---4 Backup logs

use master

BACKUP LOG chenjchdb

TO DISK='E:\chen\log\chenjchdb_20190806_23_30.trn'

WITH COMPRESSION

GO

At this point, on "how to solve SQL SERVER2012 backup log error read failure: 23" learning is over, I hope to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.