Error in SQL backup with checksum
-
Hello, I am using SQL express 2008 r2. Some times while running SQL backup query, Text
BACKUP DATABASE [DBName] TO disk = 'TargetPath' WITH CHECKSUM
I am getting the error 'detected an error on page'. But if I run query without checksum then it runs successfully. My question is, 1. Why that error is coming ? 2. What should I do if that error comes ? 3. Can I rely on the backup without checksum ? Please help me.
-
Hello, I am using SQL express 2008 r2. Some times while running SQL backup query, Text
BACKUP DATABASE [DBName] TO disk = 'TargetPath' WITH CHECKSUM
I am getting the error 'detected an error on page'. But if I run query without checksum then it runs successfully. My question is, 1. Why that error is coming ? 2. What should I do if that error comes ? 3. Can I rely on the backup without checksum ? Please help me.
Sounds like you might have some page-level corruption in your database. Try running:
DBCC CHECKDB (N'Your-Database-Name') WITH NO_INFOMSGS, ALL_ERRORMSGS;
If you still need help, you'll need to post the full error message.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Sounds like you might have some page-level corruption in your database. Try running:
DBCC CHECKDB (N'Your-Database-Name') WITH NO_INFOMSGS, ALL_ERRORMSGS;
If you still need help, you'll need to post the full error message.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
This is the error I am getting,
Msg 3043, Level 16, State 1, Line 1
BACKUP 'broken' detected an error on page (1:143) in file 'c:\sql\mydb.mdf'.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally. -
This is the error I am getting,
Msg 3043, Level 16, State 1, Line 1
BACKUP 'broken' detected an error on page (1:143) in file 'c:\sql\mydb.mdf'.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.That error message means your database is corrupt. Try running
DBCC CHECKDB, as I suggested. You'll probably need to restore your database from the most recent valid backup.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
This is the error I am getting,
Msg 3043, Level 16, State 1, Line 1
BACKUP 'broken' detected an error on page (1:143) in file 'c:\sql\mydb.mdf'.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.Brent Ozar recently published a great blog-post covering the details of what you need to do: What to Do When DBCC CHECKDB Reports Corruption[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
