All Questions
Tagged with dbcc-checkdb restore
7 questions
7
votes
1
answer
7k
views
SQL Server detected a logical consistency-based I/O error: incorrect pageid on RESTORE
The restore of our database to new server hardware failed with a page error.
Message
SQL Server detected a logical consistency-based I/O error:
incorrect pageid (expected 49:8125916; actual 49:...
- 2,239
6
votes
4
answers
3k
views
check when last backup was taken
Brent Ozar had an interesing newsletter on 2015-06-22; How do you manage dbas measuring backups, where he thinks that a good DBA should check when
the last backup was done
it was last restored
the ...
- 2,239
1
vote
1
answer
221
views
Possible to restore a damaged database's PRIMARY filegroup only?
I have a database (MyDatabase) with 2 filegroups, [PRIMARY] and [SECONDARY].
The [SECONDARY] filegroup has 2 datafiles, [DataFileA] and [DataFileB].
[DataFileA] is damaged (even after DBCC CHECKDB ...
- 631
1
vote
1
answer
465
views
Orig DB = No Corruption, Backup/restore = Corruption?
We are setting up offline DBCC CHECKDBs on an offline server so we can still do our checks, but not interfere with production.
When we backup the Master DB and restore it (even directly on a local SSD ...
- 1,781
3
votes
1
answer
4k
views
"Could not insert a backup or restore history/detail record in the msdb database" While restoring msdb
Today I found msdb database was in suspected mode, so I restored MSDB from my latest backup(As I have daily backup for this database). When I restore the MSDB database using Tsql i got below errors, ...
- 3,131
1
vote
0
answers
864
views
SQL Error 3183 on SQL Server 2012
I have a backup of database version SQL Server 2008 R2. While restoring it to SQL Server 2012 I am getting error:
msg 3183 RESTORE detected an error on page (6100:1886858449) in database ... .
...
- 295
0
votes
1
answer
725
views
dbcc checktable/checkdatabase errors after database restore
Following on from this question Error when creating an index in SQL Server 2012 we have been having problems restoring our live database back to test.
Our current production database is SQL 2005 ...
- 3,272