DB-Corruption: Backup, Restore And Recover

Oct 2, 2001

Hi

I have a question concerning backup / restore / recover of a MS-SQL-Server-Database.

Following configuration exists:

MS-SQL-Server running on NT

OS, Server located on a mirrored Raid 0 Disk -> C:

Transactionlog-Files (.ldf) on the same physical mirrored Disk -> E:

Database-Files (.mdf) located on a separate pyhisical Disk (Disk-Set, Raid 5) -> D:

I take a full backup every night of all databases, no Transaction-Log backup is made during a day (never)

Assuming following situation:

During a day one Database became corrupt. The physical-file (.ldf) of corrupted database is still accessible
on Drive E:

1. Step: I make a copy of the .ldf-File and put it on a secure place or in an other directory

2. Step: I restore the DB from the last full backup

3. Step: ???? How is it now possible to recover from the physical available .ldf-File? I know it should be
possible but I don't now how.

Has anybody tips or suggestion or has someone ever had a similar situation? Feedback would be appreciated.

Kind regards

Gabi

View 3 Replies

Restore New Database And Recover Data From Backup

Jun 13, 2014

I created a new database and want to recover data from a backup this script

use master
go
restore database new
from disk='D:
ew.bak'
go

but get an error

Message 3141, Level 16, State 0, Line 1

The database to be restored was named 'ats342'. Reissue the statement using the WITH REPLACE option to overwrite the 'new' database.
Message 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

View 1 Replies View Related

How To Recover From A Corruption

Aug 5, 2005

Paul,

Having read your useful insight into the sorts of issues around the corruptions that folk have posted in this forum I'm interested in preparing for the day when one of our servers gets corrupted :-(

Should I expect to be able to:

Restore FULL backup from Before the corruption first happened
Restore all Tranaction log backups since

and would get me back to ground zero?

I'm thinking:

if I do a DBCC CHECKDB once a week, say, immediately after a FULL backup - then if that gives me some error messages I've got last weeks Full backup and a weeks worth of Trans Log Backups to restore - which is OK for a rare disaster.

I apprecaite that the thing that caused the corruption might be a memory or disk fault, which might also have broken the creation of the backup files too - in which case I'm fairly stuffed!

Does a RESTORE do a checksum of somesort that would detect a corruption caused by, say, a memory fault or a disk controller that wrote the block faultily [twiddled some bits, but did not report error]?

In which case continuous restores of backup files to A.N.Other server would discover the moment at which a backup was "known bad"

Am I close?

Thanks

Kristen

View 9 Replies View Related

Corruption From Hardware Problems? Can I Recover?

Dec 7, 2005

Customer has called with a problem. I'm leery of their backup status (no, I'm not their hardware/network provider...I work on their ERP system...I've already read them the riot act) and I need to know if there's anything I can do to recover...I'm not optimistic.

Here's the output from DBCC CHECKDB...

Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1259646358, index ID 52111, page ID (1:743005). The PageId in the page header = (43854:429775481).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID -1026991266, index ID 2129, page (9886:-395829209). Test (PageType == WF_PAGE && dbId == TEMPDBID) failed. Values are 11 and 2.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -126484655, index ID 55768, page ID (1:783293). The PageId in the page header = (3721:-62521580).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -125632511, index ID 56405, page ID (1:719694). The PageId in the page header = (5184:-941865664).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -62026992, index ID 0, page ID (1:901154). The PageId in the page header = (59903:-3457304).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1811063, index ID 32059, page ID (1:840441). The PageId in the page header = (59485:973026048).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:493241). The PageId in the page header = (0:1).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603748). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603749). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603750). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603751). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603782). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603783). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603901). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603902). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:603904). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:717389). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:717390). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:717767). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:717768). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:718731). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:718734). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:718735). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:768697). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:768698). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:783292). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:900636). The PageId in the page header = (0:0).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1259646358)' (object ID -1259646358).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1026991266)' (object ID -1026991266).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -126484655)' (object ID -126484655).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -125632511)' (object ID -125632511).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -62026992)' (object ID -62026992).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1811063)' (object ID -1811063).
DBCC results for 'xxxxxxxxxxxx'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:900637). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:900761). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:900762). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 7, page ID (1:768597). The PageId in the page header = (0:3).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1, index ID 0, page ID (1:603899). The PageId in the page header = (1:474).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1, index ID 0, page ID (1:768707). The PageId in the page header = (23:3407872).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:719568) could not be processed. See other errors for details.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 6, index ID 0, page ID (1:719568). The PageId in the page header = (1:18159).
CHECKDB found 0 allocation errors and 25 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 23958 rows in 393 pages for object 'sysobjects'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysobjects' (object ID 1).
DBCC results for 'sysindexes'.
There are 5985 rows in 293 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).
DBCC results for 'syscolumns'.
There are 58761 rows in 1131 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 1440 rows in 23 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 29721 rows in 12393 pages for object 'syscomments'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'syscomments' (object ID 6).
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 40, index ID 0, page ID (1:498726). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 121, index ID 0, page ID (1:768699). The PageId in the page header = (121:35).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 12288, index ID 21248, page ID (1:839946). The PageId in the page header = (15057:21223).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 65795, index ID 0, page ID (1:603898). The PageId in the page header = (20:1153).
There are 49 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 12 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 25 rows in 1 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 134238 rows in 799 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 1426 rows in 8 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 40)' (object ID 40).
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 121)' (object ID 121).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 12288)' (object ID 12288).
DBCC results for 'custaddr'.
There are 99 rows in 5 pages for object 'custaddr'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 65795)' (object ID 65795).
DBCC results for 'edi_bol_item'.
There are 0 rows in 0 pages for object 'edi_bol_item'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1376256, index ID 28365, page ID (1:900893). The PageId in the page header = (28160:1224755968).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 2097184, index ID 114, page ID (1:718736). The PageId in the page header = (49:2097184).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 3145811, index ID 79, page ID (1:603897). The PageId in the page header = (51:3145776).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 4456448, index ID 61440, page ID (1:768708). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 5376768, index ID 4864, page ID (1:900894). The PageId in the page header = (375:-420663034).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 6619251, index ID 100, page ID (1:721759). The PageId in the page header = (101:7602287).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 6619251, index ID 100, page ID (1:721760). The PageId in the page header = (101:7602287).
DBCC results for 'pos_chg'.
There are 0 rows in 0 pages for object 'pos_chg'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1376256)' (object ID 1376256).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2097184)' (object ID 2097184).
DBCC results for 'tmp_snapshot_jrtresourcegroup'.
There are 0 rows in 0 pages for object 'tmp_snapshot_jrtresourcegroup'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 3145811)' (object ID 3145811).
DBCC results for 'fs_pck_hdr'.
There are 0 rows in 0 pages for object 'fs_pck_hdr'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 4456448)' (object ID 4456448).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 5376768)' (object ID 5376768).
CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 6619251)' (object ID 6619251).
DBCC results for 'co_all'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 7209077, index ID 395, page ID (1:722425). The PageId in the page header = (107:6488169).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 0, page ID (1:901016). The PageId in the page header = (1:804477).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 0, page ID (1:901017). The PageId in the page header = (1:804479).
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235043) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235044) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235045) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235046) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235047) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235048) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235049) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235050) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235051) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235052) was not encountered.
There are 0 rows in 0 pages for object 'co_all'.
DBCC results for 'glrpth'.
There are 11 rows in 1 pages for object 'glrpth'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 7209077)' (object ID 7209077).
DBCC results for 'user_index_committed'.
There are 1 rows in 1 pages for object 'user_index_committed'.
DBCC results for 'apparms'.
There are 1 rows in 1 pages for object 'apparms'.
DBCC results for 'ledger_all'.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235053) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235054) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235055) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235056) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235057) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235058) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235059) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235060) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235061) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235062) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235063) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:235064) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359864) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359880) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359881) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359882) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359883) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359884) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359885) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359886) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:359887) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:385326) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:408802) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:408803) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:408804) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:412328) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:412329) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:412330) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:412331) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:412332) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:435522) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:485390) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:487086) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:487087) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:490919) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:578392) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:608986) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:608987) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:608988) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:630976) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:643147) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:643151) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:643185) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:643186) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:643187) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:669829) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:676981) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:676982) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:683022) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:683023) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:683040) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:685275) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:692884) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:692885) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:692886) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:696260) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:696261) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:696262) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:696263) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:707071) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:724478) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:724479) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:729245) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:729246) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:735165) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:744248) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:744249) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:744250) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:757566) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:759028) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:759029) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:759030) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:779720) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:779721) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:779722) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:792333) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:804221) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:808024) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 8491209, index ID 2. Parent node for page (1:846820) was not encountered.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 8491209, index ID 2: Page (1:901016) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 8491209, index ID 2: Page (1:901017) could not be processed. See other errors for details.
There are 665337 rows in 26433 pages for object 'ledger_all'.
CHECKDB found 0 allocation errors and 93 consistency errors in table 'ledger_all' (object ID 8491209).
DBCC results for 'itemprice'.
There are 0 rows in 0 pages for object 'itemprice'.
DBCC results for 'fs_serv_type'.
There are 0 rows in 0 pages for object 'fs_serv_type'.
DBCC results for 'RGRPSUM000'.
There are 0 rows in 0 pages for object 'RGRPSUM000'.
DBCC results for 'mcal_all'.
There are 0 rows in 0 pages for object 'mcal_all'.
DBCC results for 'system_type'.
There are 14 rows in 1 pages for object 'system_type'.
DBCC results for 'fs_warr_code'.
There are 0 rows in 0 pages for object 'fs_warr_code'.
DBCC results for 'pitemh'.
There are 0 rows in 0 pages for object 'pitemh'.
DBCC results for 'slparms'.
There are 0 rows in 0 pages for object 'slparms'.
DBCC results for 'tt_arpost'.
There are 0 rows in 1 pages for object 'tt_arpost'.
DBCC results for 'jobitem'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 42861158, index ID 2976, page ID (1:498725). The PageId in the page header = (654:42861198).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 50255384, index ID 7: Page (1:901152) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 50255384, index ID 7, page (1:901152). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 50255384, index ID 7: Page (1:901153) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 50255384, index ID 7: Page (1:901154) could not be processed. See other errors for details.
There are 0 rows in 0 pages for object 'jobitem'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 42861158)' (object ID 42861158).
DBCC results for 'sfcparms'.
There are 1 rows in 1 pages for object 'sfcparms'.
DBCC results for 'custtype'.
There are 0 rows in 0 pages for object 'custtype'.
DBCC results for 'jobtran'.
There are 0 rows in 0 pages for object 'jobtran'.
DBCC results for 'pertot_all'.
There are 18292 rows in 449 pages for object 'pertot_all'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'pertot_all' (object ID 50255384).
DBCC results for 'dcco_serial'.
There are 0 rows in 0 pages for object 'dcco_serial'.
DBCC results for 'fs_tmp_recon'.
There are 0 rows in 0 pages for object 'fs_tmp_recon'.
DBCC results for 'preq_all'.
There are 0 rows in 0 pages for object 'preq_all'.
DBCC results for 'unitcd2_all'.
There are 82 rows in 2 pages for object 'unitcd2_all'.
DBCC results for 'RESMNT000'.
There are 0 rows in 0 pages for object 'RESMNT000'.
DBCC results for 'jobroute'.
There are 0 rows in 0 pages for object 'jobroute'.
Server: Msg 8928, Level 16, State 2, Line 1
Object ID 66359551, index ID 3: Page (1:718736) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 66359551, index ID 5: Page (1:839944) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 66359551, index ID 5, page (1:839944). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 66359551, index ID 5: Page (1:839945) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 66359551, index ID 5: Page (1:839946) could not be processed. See other errors for details.
DBCC results for 'tmp_snapshot_aptrx'.
There are 14590 rows in 879 pages for object 'tmp_snapshot_aptrx'.
CHECKDB found 0 allocation errors and 5 consistency errors in table 'tmp_snapshot_aptrx' (object ID 66359551).
DBCC results for 'fs_oper_code'.
There are 68 rows in 2 pages for object 'fs_oper_code'.
DBCC results for 'prod_mix_item'.
There are 0 rows in 0 pages for object 'prod_mix_item'.
DBCC results for 'NoteTypes'.
There are 2 rows in 1 pages for object 'NoteTypes'.
DBCC results for 'empabsence'.
There are 0 rows in 0 pages for object 'empabsence'.
DBCC results for 'reason'.
There are 4 rows in 1 pages for object 'reason'.
DBCC results for 'emp_salary'.
There are 0 rows in 0 pages for object 'emp_salary'.
DBCC results for 'inv_map'.
There are 0 rows in 0 pages for object 'inv_map'.
DBCC results for 'taxparms'.
There are 1 rows in 1 pages for object 'taxparms'.
DBCC results for 'con_inv_item'.
There are 0 rows in 0 pages for object 'con_inv_item'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'POLSCHD000'.
There are 0 rows in 0 pages for object 'POLSCHD000'.
DBCC results for 'fs_item_mnt'.
There are 0 rows in 0 pages for object 'fs_item_mnt'.
DBCC results for 'empmemo'.
There are 0 rows in 0 pages for object 'empmemo'.
DBCC results for 'fs_distacct'.
There are 0 rows in 0 pages for object 'fs_distacct'.
DBCC results for 'MATL000'.
There are 9 rows in 1 pages for object 'MATL000'.
DBCC results for 'grn_hdr'.
There are 0 rows in 0 pages for object 'grn_hdr'.
DBCC results for 'fs_bol'.
There are 0 rows in 0 pages for object 'fs_bol'.
DBCC results for 'lot_loc'.
There are 0 rows in 0 pages for object 'lot_loc'.
DBCC results for 'matltrack'.
There are 0 rows in 0 pages for object 'matltrack'.
DBCC results for 'del_term_all'.
There are 0 rows in 0 pages for object 'del_term_all'.
DBCC results for 'vendtype'.
There are 0 rows in 0 pages for object 'vendtype'.
DBCC results for 'MATLDELV000'.
There are 0 rows in 1 pages for object 'MATLDELV000'.
DBCC results for 'fs_consumer'.
There are 0 rows in 0 pages for object 'fs_consumer'.
DBCC results for 'tmp_snapshot_appmt'.
There are 29 rows in 5 pages for object 'tmp_snapshot_appmt'.
DBCC results for 'JS16VR000'.
There are 0 rows in 0 pages for object 'JS16VR000'.
DBCC results for 'vacparms'.
There are 0 rows in 0 pages for object 'vacparms'.
DBCC results for 'exam'.
There are 0 rows in 0 pages for object 'exam'.
DBCC results for 'edi_sched_dtl'.
There are 0 rows in 0 pages for object 'edi_sched_dtl'.
DBCC results for 'pricematrix_all'.
There are 0 rows in 0 pages for object 'pricematrix_all'.
DBCC results for 'wbs_item'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 141688844, index ID 3142, page ID (1:721639). The PageId in the page header = (64589:-1994376176).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:603781) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 0, page (1:603781). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:603782) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:603783) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:717388) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 0, page (1:717388). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:717389) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:717390) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:719692) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 0, page (1:719692). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:719693) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:719694) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:721637) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 0, page (1:721637). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:721638) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:721639) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:722424) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:722425) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:840439) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 0, page (1:840439). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:900892) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 0, page (1:900892). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:900893) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 0: Page (1:900894) could not be processed. See other errors for details.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:35296) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86921) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86922) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86923) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86924) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86925) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86926) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86927) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:86928) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:482724) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:482725) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:482726) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:482727) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:502031) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:513852) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:513853) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:513854) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:513855) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:516019) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:516020) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:517676) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:517677) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:517678) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:527438) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:539083) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:539084) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:539085) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:539086) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858064) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858065) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858066) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858067) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858069) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858070) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:858071) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866752) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866753) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866754) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866755) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866756) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866757) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866758) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:866759) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870488) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870489) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870490) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870491) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870492) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870493) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870494) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:870495) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:884588) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:884589) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:887976) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:888845) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896360) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896361) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896362) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896363) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896364) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896367) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:896888) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897622) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897623) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897840) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897841) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897842) was not encountered.
There are 0 rows in 0 pages for object 'wbs_item'.
DBCC results for 'poblnchg'.
There are 0 rows in 0 pages for object 'poblnchg'.
DBCC results for 'chart'.
There are 181 rows in 5 pages for object 'chart'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 141688844)' (object ID 141688844).
DBCC results for 'fadisp'.
There are 0 rows in 0 pages for object 'fadisp'.
DBCC results for 'pos_class'.
There are 0 rows in 0 pages for object 'pos_class'.
DBCC results for 'rsvd_inv'.
There are 0 rows in 0 pages for object 'rsvd_inv'.
DBCC results for 'APPSTRLIST'.
There are 80 rows in 2 pages for object 'APPSTRLIST'.
DBCC results for 'shipproc'.
There are 0 rows in 0 pages for object 'shipproc'.
DBCC results for 'fs_partner_all'.
There are 404 rows in 9 pages for object 'fs_partner_all'.
DBCC results for 'aps_site'.
There are 0 rows in 0 pages for object 'aps_site'.
DBCC results for 'PARTSUM000'.
There are 0 rows in 0 pages for object 'PARTSUM000'.
DBCC results for 'mchearn'.
There are 0 rows in 0 pages for object 'mchearn'.
DBCC results for 'journal_all'.
There are 5664 rows in 230 pages for object 'journal_all'.
DBCC results for 'featrank_all'.
There are 0 rows in 0 pages for object 'featrank_all'.
DBCC results for 'tmp_job_split'.
There are 0 rows in 0 pages for object 'tmp_job_split'.
DBCC results for 'table_class'.
There are 8 rows in 1 pages for object 'table_class'.
DBCC results for 'CAL000'.
There are 0 rows in 0 pages for object 'CAL000'.
DBCC results for 'coh_all'.
There are 0 rows in 0 pages for object 'coh_all'.
DBCC results for 'fabonus'.
There are 0 rows in 0 pages for object 'fabonus'.
DBCC results for 'tt_finstmt'.
There are 0 rows in 0 pages for object 'tt_finstmt'.
DBCC results for 'ClassNotes'.
There are 0 rows in 0 pages for object 'ClassNotes'.
DBCC results for 'rma'.
There are 0 rows in 0 pages for object 'rma'.
DBCC results for 'rev_ms_log'.
There are 0 rows in 0 pages for object 'rev_ms_log'.
DBCC results for 'prhrs'.
There are 0 rows in 0 pages for object 'prhrs'.
DBCC results for 'unitcd3'.
There are 0 rows in 0 pages for object 'unitcd3'.
DBCC results for 'tmp_staging_prtrx'.
There are 0 rows in 0 pages for object 'tmp_staging_prtrx'.
DBCC results for 'fs_taxcode'.
There are 0 rows in 0 pages for object 'fs_taxcode'.
DBCC results for 'License'.
There are 1 rows in 1 pages for object 'License'.
DBCC results for 'dcitem'.
There are 0 rows in 0 pages for object 'dcitem'.
DBCC results for 'fs_tmp_sro_copy'.
There are 0 rows in 1 pages for object 'fs_tmp_sro_copy'.
DBCC results for 'arparms'.
There are 1 rows in 1 pages for object 'arparms'.
DBCC results for 'fs_sro_labor'.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897843) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897844) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897845) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897846) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:897847) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:900632) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:900633) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:900634) was not encountered.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 3: Page (1:900635) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3, page (1:900635). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 3: Page (1:900636) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 204332288, index ID 3: Page (1:900637) could not be processed. See other errors for details.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:900638) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 204332288, index ID 3. Parent node for page (1:900639) was not encountered.
There are 579706 rows in 84159 pages for object 'fs_sro_labor'.
CHECKDB found 0 allocation errors and 105 consistency errors in table 'fs_sro_labor' (object ID 204332288).
DBCC results for 'prospect'.
There are 0 rows in 0 pages for object 'prospect'.
DBCC results for 'prtrx'.
There are 0 rows in 0 pages for object 'prtrx'.
DBCC results for 'custtype_all'.
There are 0 rows in 0 pages for object 'custtype_all'.
DBCC results for 'fs_sro'.
There are 3805 rows in 398 pages for object 'fs_sro'.
DBCC results for 'tt_glbank'.
There are 0 rows in 0 pages for object 'tt_glbank'.
DBCC results for 'per_sort'.
There are 2 rows in 1 pages for object 'per_sort'.
DBCC results for 'user_class_committed'.
There are 8 rows in 1 pages for object 'user_class_committed'.
DBCC results for 'JSATTR000'.
There are 0 rows in 0 pages for object 'JSATTR000'.
DBCC results for 'slsclass'.
There are 0 rows in 0 pages for object 'slsclass'.
DBCC results for 'BATRL000'.
There are 0 rows in 0 pages for object 'BATRL000'.
DBCC results for 'user_index_fld'.
There are 1 rows in 1 pages for object 'user_index_fld'.
DBCC results for 'dept'.
There are 87 rows in 4 pages for object 'dept'.
DBCC results for 'itemwhse'.
There are 9 rows in 1 pages for object 'itemwhse'.
DBCC results for 'dcsfc_item'.
There are 0 rows in 0 pages for object 'dcsfc_item'.
DBCC results for 'fs_stat_code'.
There are 5 rows in 1 pages for object 'fs_stat_code'.
DBCC results for 'curracct'.
There are 1 rows in 1 pages for object 'curracct'.
DBCC results for 'POOL000'.
There are 0 rows in 0 pages for object 'POOL000'.
DBCC results for 'PrintPreview'.
There are 1 rows in 1 pages for object 'PrintPreview'.
DBCC results for 'chart_d'.
There are 0 rows in 0 pages for object 'chart_d'.
DBCC results for 'vend_lcr'.
There are 0 rows in 0 pages for object 'vend_lcr'.
DBCC results for 'aptrxr'.
There are 5 rows in 1 pages for object 'aptrxr'.
DBCC results for 'prbank'.
There are 0 rows in 0 pages for object 'prbank'.
DBCC results for 'coitem_log'.
There are 0 rows in 0 pages for object 'coitem_log'.
DBCC results for 'progbill'.
There are 0 rows in 0 pages for object 'progbill'.
DBCC results for 'ObjectBuildMessages'.
There are 6609 rows in 121 pages for object 'ObjectBuildMessages'.
DBCC results for 'empaward'.
There are 0 rows in 0 pages for object 'empaward'.
DBCC results for 'fs_pckitem'.
There are 0 rows in 0 pages for object 'fs_pckitem'.
DBCC results for 'RELRECS'.
There are 119 rows in 2 pages for object 'RELRECS'.
DBCC results for 'fs_parms'.
There are 1 rows in 1 pages for object 'fs_parms'.
DBCC results for 'custdrft'.
There are 0 rows in 0 pages for object 'custdrft'.
DBCC results for 'exc_mesg'.
There are 0 rows in 0 pages for object 'exc_mesg'.
DBCC results for 'transfer_all'.
There are 0 rows in 0 pages for object 'transfer_all'.
DBCC results for 'empreview'.
There are 0 rows in 0 pages for object 'empreview'.
DBCC results for 'fs_work_code'.
There are 5 rows in 1 pages for object 'fs_work_code'.
DBCC results for 'app_int'.
There are 0 rows in 0 pages for object 'app_int'.
DBCC results for 'shipto'.
There are 3 rows in 1 pages for object 'shipto'.
DBCC results for 'TBLLIST000'.
There are 0 rows in 0 pages for object 'TBLLIST000'.
DBCC results for 'projlabr'.
There are 0 rows in 0 pages for object 'projlabr'.
DBCC results for 'edi_cust'.
There are 0 rows in 0 pages for object 'edi_cust'.
DBCC results for 'JS3VR000'.
There are 0 rows in 0 pages for object 'JS3VR000'.
DBCC results for 'faclass'.
There are 79 rows in 5 pages for object 'faclass'.
DBCC results for 'PBOM000'.
There are 0 rows in 0 pages for object 'PBOM000'.
DBCC results for 'inv_ms'.
There are 0 rows in 0 pages for object 'inv_ms'.
DBCC results for 'wc'.
There are 0 rows in 0 pages for object 'wc'.
DBCC results for 'feature'.
There are 0 rows in 0 pages for object 'feature'.
DBCC results for 'fadist'.
There are 0 rows in 0 pages for object 'fadist'.
DBCC results for 'unitcd3_all'.
There are 0 rows in 0 pages for object 'unitcd3_all'.
DBCC results for 'ins_age'.
There are 0 rows in 0 pages for object 'ins_age'.
DBCC results for 'edi_co'.
There are 0 rows in 0 pages for object 'edi_co'.
DBCC results for 'tmp_arpmt'.
There are 0 rows in 1 pages for object 'tmp_arpmt'.
DBCC results for 'edi_vinv'.
There are 0 rows in 0 pages for object 'edi_vinv'.
DBCC results for 'emp_stat'.
There are 0 rows in 0 pages for object 'emp_stat'.
DBCC results for 'LOADPERF000'.
There are 0 rows in 0 pages for object 'LOADPERF000'.
DBCC results for 'certification'.
There are 0 rows in 0 pages for object 'certification'.
DBCC results for 'vch_pr_stax'.
There are 0 rows in 0 pages for object 'vch_pr_stax'.
DBCC results for 'coh_bl'.
There are 0 rows in 0 pages for object 'coh_bl'.
DBCC results for 'prparms'.
There are 1 rows in 1 pages for object 'prparms'.
DBCC results for 'ATTRIB000'.
There are 0 rows in 0 pages for object 'ATTRIB000'.
DBCC results for 'matltrack_all'.
There are 0 rows in 0 pages for object 'matltrack_all'.
DBCC results for 'RegByRoute'.
There are 73 rows in 1 pages for object 'RegByRoute'.
DBCC results for 'fs_cont_line'.
There are 0 rows in 0 pages for object 'fs_cont_line'.
DBCC results for 'rsvd_inv_all'.
There are 0 rows in 0 pages for object 'rsvd_inv_all'.
DBCC results for 'con_inv_line'.
There are 0 rows in 0 pages for object 'con_inv_line'.
DBCC results for 'cust_lcr'.
There are 0 rows in 0 pages for object 'cust_lcr'.
DBCC results for 'pos_det'.
There are 0 rows in 0 pages for object 'pos_det'.
DBCC results for 'slsman'.
There are 0 rows in 0 pages for object 'slsman'.
DBCC results for 'lot_loc_all'.
There are 0 rows in 0 pages for object 'lot_loc_all'.
DBCC results for 'mchscrp'.
There are 0 rows in 0 pages for object 'mchscrp'.
DBCC results for 'tt_inv_adj'.
There are 0 rows in 0 pages for object 'tt_inv_adj'.
DBCC results for 'tmp_snapshot_prtrx'.
There are 0 rows in 0 pages for object 'tmp_snapshot_prtrx'.
DBCC results for 'BATSUM000'.
There are 0 rows in 0 pages for object 'BATSUM000'.
DBCC results for 'curracct_all'.
There are 1 rows in 1 pages for object 'curracct_all'.
DBCC results for 'mrp_parm_all'.
There are 1 rows in 1 pages for object 'mrp_parm_all'.
DBCC results for 'co'.
There are 0 rows in 0 pages for object 'co'.
DBCC results for 'apparms_all'.
There are 1 rows in 1 pages for object 'apparms_all'.
DBCC results for 'fs_item_surcharge'.
There are 0 rows in 0 pages for object 'fs_item_surcharge'.
DBCC results for 'edi_poitem'.
There are 0 rows in 0 pages for object 'edi_poitem'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 427606534, index ID 10265, page ID (1:721638). The PageId in the page header = (57697:-1497103250).
DBCC results for 'pricecode'.
There are 0 rows in 0 pages for object 'pricecode'.
DBCC results for 'aptrx'.
There are 3 rows in 1 pages for object 'aptrx'.
DBCC results for 'trans_nature'.
There are 0 rows in 0 pages for object 'trans_nature'.
DBCC results for 'prlog'.
There are 0 rows in 0 pages for object 'prlog'.
DBCC results for 'fs_item_rate'.
There are 0 rows in 0 pages for object 'fs_item_rate'.
DBCC results for 'dept_supv'.
There are 0 rows in 0 pages for object 'dept_supv'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 427606534)' (object ID 427606534).
DBCC results for 'JSTYPE'.
There are 39 rows in 1 pages for object 'JSTYPE'.
DBCC results for 'chart_d_all'.
There are 0 rows in 0 pages for object 'chart_d_all'.
DBCC results for 'empskill'.
There are 0 rows in 0 pages for object 'empskill'.
DBCC results for 'prdecd'.
There are 0 rows in 0 pages for object 'prdecd'.
DBCC results for 'table_class_committed'.
There are 8 rows in 1 pages for object 'table_class_committed'.
DBCC results for 'empcert'.
There are 0 rows in 0 pages for object 'empcert'.
DBCC results for 'ReplicatedRows3'.
There are 0 rows in 0 pages for object 'ReplicatedRows3'.
DBCC results for 'app_ref'.
There are 0 rows in 0 pages for object 'app_ref'.
DBCC results for 'user_index_fld_committed'.
There are 1 rows in 1 pages for object 'user_index_fld_committed'.
DBCC results for 'jour_hdr'.
There are 13 rows in 1 pages for object 'jour_hdr'.
DBCC results for 'coitem_log_all'.
There are 0 rows in 0 pages for object 'coitem_log_all'.
DBCC results for 'unitcd4'.
There are 5 rows in 1 pages for object 'unitcd4'.
DBCC results for 'dcsfc_serial'.
There are 0 rows in 0 pages for object 'dcsfc_serial'.
DBCC results for 'ObjectMainMessages'.
There are 16304 rows in 457 pages for object 'ObjectMainMessages'.
DBCC results for 'tmp_snapshot_job'.
There are 0 rows in 0 pages for object 'tmp_snapshot_job'.
DBCC results for 'ship_lang'.
There are 0 rows in 0 pages for object 'ship_lang'.
DBCC results for 'termination'.
There are 0 rows in 0 pages for object 'termination'.
DBCC results for 'user_class_fld'.
There are 14 rows in 1 pages for object 'user_class_fld'.
DBCC results for 'tmp_MessageBuffer'.
There are 0 rows in 0 pages for object 'tmp_MessageBuffer'.
DBCC results for 'facost'.
There are 0 rows in 0 pages for object 'facost'.
DBCC results for 'fs_tmp'.
There are 0 rows in 0 pages for object 'fs_tmp'.
DBCC results for 'fs_bol_item'.
There are 0 rows in 0 pages for object 'fs_bol_item'.
DBCC results for 'JS11VR000'.
There are 0 rows in 0 pages for object 'JS11VR000'.
DBCC results for 'item_glbl'.
There are 9 rows in 1 pages for object 'item_glbl'.
DBCC results for 'cfg_attr'.
There are 0 rows in 0 pages for object 'cfg_attr'.
DBCC results for 'vch_dist'.
There are 17342 rows in 345 pages for object 'vch_dist'.
DBCC results for 'experience'.
There are 0 rows in 0 pages for object 'experience'.
DBCC results for 'glrpthc'.
There are 41 rows in 1 pages for object 'glrpthc'.
DBCC results for 'LOADSUM000'.
There are 0 rows in 0 pages for object 'LOADSUM000'.
DBCC results for 'dcitem_serial'.
There are 0 rows in 0 pages for object 'dcitem_serial'.
DBCC results for 'taxparms_all'.
There are 1 rows in 1 pages for object 'taxparms_all'.
DBCC results for 'famaster'.
There are 0 rows in 0 pages for object 'famaster'.
DBCC results for 'matlearn'.
There are 0 rows in 0 pages for object 'matlearn'.
DBCC results for 'tt_jobt_cls'.
There are 0 rows in 0 pages for object 'tt_jobt_cls'.
DBCC results for 'do_line'.
There are 0 rows in 0 pages for object 'do_line'.
DBCC results for 'matltran'.
There are 363046 rows in 12597 pages for object 'matltran'.
DBCC results for 'chart_all'.
There are 181 rows in 5 pages for object 'chart_all'.
DBCC results for 'projmatl'.
There are 0 rows in 0 pages for object 'projmatl'.
DBCC results for 'edi_inv_hdr'.
There are 0 rows in 0 pages for object 'edi_inv_hdr'.
DBCC results for 'progh'.
There are 0 rows in 0 pages for object 'progh'.
DBCC results for 'resourcetype'.
There are 0 rows in 0 pages for object 'resourcetype'.
DBCC results for 'tmp_snapshot_prtrxd'.
There are 0 rows in 0 pages for object 'tmp_snapshot_prtrxd'.
DBCC results for 'JS17VR000'.
There are 0 rows in 0 pages for object 'JS17VR000'.
DBCC results for 'currate'.
There are 0 rows in 0 pages for object 'currate'.
DBCC results for 'ReplicatedRowsErrors'.
There are 0 rows in 0 pages for object 'ReplicatedRowsErrors'

View 3 Replies View Related

DB Is Marked Restore Pending Which May Indicate Disk Corruption

Apr 27, 2015

i have a SQL 2008 R2 RTM production instance, in which we run dBCC CheckDB every weekend to check on the DB. This weekend this sql job returned the error:

DBCC RESULTS
--------------------
<DbccResults>
<Dbcc ID="0" Error="8928" Severity="16" State="1">Object ID 866531312, index ID 1, partition ID 72057602979266560
, alloc unit ID 72057603064397824 (type In-row data): Page (1:7650240) could not be processed. See other errors
for details.</Dbcc>
<Dbcc ID="1" Error="8939" Severity="16" State="98">Table error: Object ID 866531312, index ID 1, partition ID 720
57602979266560, alloc unit ID 72057603064397824 (type In-row data), page (1:7650240). Test (IS_OFF (BUF_IOERR, pB
UF->bstat)) failed. Values are 12716041 and -6.</Dbcc>
<Dbcc ID="2" Error="8990" Severity="10" State="1">CHECKDB found 0 allocation errors and 2 consistency errors in t
able 'tblDistpatch' (object ID 866531312).</Dbcc>

We tried to rebuild the indexes in the table: tblDistpatch...the non clustered indexes ran fine however the cluster index rebuilt returned an error:

Error: The statement has been terminated.
Msg 829, Level 21, State 1, Line 1

Database ID 3, Page (1:7650240) is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.in TEST environment we were able to reproduce this error by restoring latest backup.

we ran :

dbcc checktable (tblDistpatch ,REPAIR_ALLOW_DATA_LOSS )

then we ran dbcc checkdb and no errors where found.

my question comes with in your experience is this the best possible way to fix this table?only one table, but running this in production environment will required to put db in single user mode first.

View 7 Replies View Related

Corruption Of Backup File On Remote Server

Jul 19, 2006

Dear all,

What I want to do is to backup my database through the SQL script, when the backup is successful, the .bak file is saved in my local harddisk. After that, I used the XYRunProc to execute a "copy" command to copy the .bak file to a remote server.

However, when I want to restore the database using the .bak on the remote server, I found that the .bak is corrupted. This problem does not exist if the file is copied to the remote server manually (click copy on local server and click paste on remote server).

Do anyone know what's the problem of this? This really made me very frustrated. Hope someone can help me, thank you very much!

Regards,
Strike

View 1 Replies View Related

Restore / Recover SQL Database From Data File

Feb 24, 2002

Our SQL database log file got physically deleted. Now the database is in suspect mode. Is it possible to recover / restore the database just with the data file.

View 3 Replies View Related

Database Backup And Recover

Jul 14, 2003

Hi all:
In order to test database restore, I create a backup driver and puporse delete one table, then I try to restore my databse use backup, but the delete table donot show up.

Thank you

View 5 Replies View Related

Recover The Backup Set With MSDB

Apr 13, 2007

I am facing the Database recovery problems sicne I have lost my MSDB db , only i have the Complete db backup and transactional backup.

How do i can recover the database since i don't have the MSDB database

View 3 Replies View Related

Recover Just One Table From Backup

Sep 6, 2007

I work on sql server 2000.
Is it possble to recover just one table from the database backup ???
I am new to this.

Please let me know.
thanks

View 1 Replies View Related

Data Warehouse Backup/recover

Jun 9, 2004

Hello, everyone:

Does any body have the experience to execute data warehouse backup/recover? What I want to know is how to backup/recover database in data warehouse and cubes.

Thanks.

ZYT

View 5 Replies View Related

How Do I Recover Database From A Detached Backup Device?

Nov 29, 2007

I ran into a problem today where I had to pull a backup file from an older tape. The file was originally is a backup that was stored in a device like :

EXEC sp_addumpdevice
'disk', --type
'c2000_BackupDevice', --logical name
'\UNCPathackupFile.bak' --physical location

I put the file from the tape on a File Server and then tried to create a new backup device pointing to the file. That's easy enough, but when I try to restore from it I get an device error saying it's offline.

How can I get that device attached to my server and then extract the backup files stored inside it?

Please advise b/c this is an interesting problem I hadn't anticipated and it argues that I should change my backup strategy .

Thanks for any advice/experience you can provide,

alex8675

View 2 Replies View Related

Backup Failed In Loading Status. How To Restart Or Recover?

Jun 18, 2007

I asked this question before but never received a decent answer. When a restore fails, what are the steps to re-start the restore? This should be a very common issue and for the life of me I have been unable to find it in BOL or the MS site! Please let me in on the secret!!

Thanks

View 3 Replies View Related

Transact SQL :: Backup / Restore Tools Which Can Restore Multiple Environments

Jun 25, 2015

I am looking for a SQL Backup/Restore tools which can restore multiple environments. Here is high level requirements.

1. We have 4 DBs, range from 1 TB - 1.5 TB Each Database. When we restore to QA, DEV, or Staging, we usually restore 4 of them.
2. I am looking for the speed to complete restoring between 1 - 2 hours for 4 DBs.

I am evaluating the Dephix Software but the setup is very complex and its given us a lot of issues with Windows Authentions, and failure in the middle of the backup. I used Guess Software many years ago but can't find it on the web site any more. Speed is very important for us mean complete restoring as fast as possible. We are on SQL 2012 and SQL 2008 R2.We are currently using NETAPP Technology and I have Redgate Backup Tool but I am mainly looking for fast Restore Process.

View 4 Replies View Related

SQL Server Admin 2014 :: Restore DB With Full Backup And Transactional Log Backup

Aug 3, 2015

Need to restore database,here's the scenario:

Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.

View 8 Replies View Related

How To Restore A Database From Backup With A Splitted Backup File

Apr 1, 2008

I should restore a SQL Server 2005 Database from backup. The backup contains three files, named user.bak0, user.bak1 and user.bak2.

How is the syntax of the restore filelistonly and the restore database ... ?

I usualy write
restore filelistonly from disk = 'path and filenam.bak'
restore database. zy
from disk = 'path and filename.bak'
with replace,
move.....
move....

This works but I cannot use it with a splitted backup file. The files are much too big to put together to one file.

Thanks in advance for any help.

View 3 Replies View Related

How To Restore Database From Full Backup And Several Diff Backup

Oct 17, 2006

I have a full backup and several diff backup,now i want to restore

firstly,I restore full backup

RESTORE DATABASE ***
FROM DISK = 'D:databackup200610140000.bak'
WITH NORECOVERY
GO

it's working,then i don;'t know how to continue

Thanks in advance

View 3 Replies View Related

Is It Possible To Restore From A Database Backup Without A Transaction Log Backup?

Oct 14, 2007

I neglected to backup the transaction log as part of the process of backing up the database. Now i only have the backup file for the database and no transaction log backup. When i try to do a restore on the database, i get the error on a "tail log missing" message (which i'm assuming is that it's looking for the t-log backup?).

Is it possible to restore or even restore to a new database? I'm only looking to retreive data from 2 tables within the backup file.

Thanks!

SQL Server 2005 on Windows 2003 Server x64.

View 16 Replies View Related

Restore Backup

May 17, 2006

I had to replace my hard drive which was going bad. I reinstalled Sql 2005 and now need to restore the backup that I have. I selected Restore Database and chose From Device, and selected the backup location on J: drive and selected the backup file which has no extenstion. I checked the checkbox next to the backup set to restore. Click OK and then I get this error message:
Restore failed for Server
System.Data.SqlClient.SqlError: Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataMyDB_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
I don't know why it is looking for a MDF file as this was never in the Backup folder. Can someone please help me on this? I thought I was doing the right thing making a backup all along and now I can't restore it!

View 2 Replies View Related

Backup/Restore

Dec 17, 2001

Is it possisable to restore from tape when the backup was taken from a
different server. ServerA has the tape drive which performs the backups
to tape, but ServerB which is under a different domain wants to restore ServerA database on ServerB, both databases on the two servers are the same
is it possiable to restore a database on ServerB using ServerA file?

View 2 Replies View Related

Backup/restore

May 7, 2001

hello all !!
I suffered a crash on one of my disks on a server runing MS-sql 7.0,and found out my backupexec dosnt really restore a runing version of my database.
which solution would you recomend ,taking in acount i may have a copy of the database on another computer,which files i can restore?
thanks
yochai lam

View 2 Replies View Related

Backup /Restore

May 24, 2001

Hi I am operating my databases under "trunc log on checkpoint" mode as I do not need point of failure recoverability.I was performing a recovery test using a backup which resulted in it being unsuccessful .Error Message received was
"Recovery has failed because a nonlogged operation could not be redone.Use the RESTORE statement to restore all data in filegroup PRIMARY to a pt beyond the nonlogged changes"

Isnt sql*server supposed to prevent a non-logged operation while a backup is in progress?Also how do i prevent such a situation from recurring.
If i switch to single user mode before a backup how do i prevent exisiting users from accessing ... without bouncing my sql*server?

View 1 Replies View Related

Backup And Restore

Sep 25, 2001

Hi Everyone,

I did a restore of database the user the original database is admin where it says the user is dbo.

After i did the restore i was able to add admin as user and dbowner but when i tried to change the user it said the user already exists.

How do i create the same..enviroment as or the original system with users..i saw a problem i i drop the user and them recreate it then it cannot find the object or the object which are owned by it are lost..could any one help me with this ...so as how to and what do i need to keep track of while restoring the database and configure the server back with same user names and permissions.

Thanks.

Kavitha

View 1 Replies View Related

Backup And Restore

Sep 15, 2000

Hi,

I have two databases on two different SQL Servers,our application is updating these two databases simultaniously.So every time these two databases will be in synchronized state.
Now i want to schedule backup for these two Databases.How can i take backup of these two databases at single point of time.
so that if i restore these two backups on corresponding servers,There should not be any conflicts.

Any suggetions please....
Ananth

View 1 Replies View Related

BACKUP AND RESTORE

Sep 6, 2000

How can I backup and restore a database from one server to another. I am new in this business. I need your help please!!!

View 3 Replies View Related

Backup And Restore

Jan 29, 2001

I'm trying to backup a database to remote server first i did add a device using USE master

EXEC sp_addumpdevice 'disk', 'NetworkDevice', 'cabaanpubs.bak'

then

BACKUP DATABASE pubs TO NetworkDevice

it gives me an error saying

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'NetworkDevice'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

I don't really understand what's goin.

basically i need to synchronize my production database so what am i planning is to take a full backup on that server everynight and then restore it back.

Can some one guide me to take a backup as well as restore on the remoteserver with syntax and what does it mean to add a device...i could not understand.

Is there any other process that's much faster to implement.

i appriciate your support and help .

View 1 Replies View Related

Restore Of Backup

Aug 30, 2000

Whenever I restore a backup on sqlserver 7.0 and create a new database from it, I always end up having problems with the users existing in the backup.

To enable those users to have access, I end up creating logins with those names and when I try granting those users Database access, I get the error message that the user already exists in the database.

Could some one tell me the right way to restore the backup and having all the users of the database also restored in the proper manner.

View 3 Replies View Related

Backup & Restore

Dec 13, 1999

WE are using sqlserver 7.0 & backing full database using Seagate backup ver 7.2 on a tape drive.

I have following questions if anybody could help

1]How do I restore a single table backup from the tape backup without restoring the full database first on the disk & then running import/export
utility to transfer/ copy that particular table to production database.
Is there any third party backup utility which allows for a single / selected table restore?

2]What are the steps or if anybody has the script for tansfering logins/users
with permisssions & without deencrypting the passwords when transfering from one server to another server.

View 1 Replies View Related

Backup And Restore

Nov 26, 2006

Hi there,
I am new to administration. i would like to create a development environment out of production database.
for this i have to backup the production database on a regular basis. then use this backup and restore it to a database on different. i can do this task, but i want to automate this task to do it on regular basis.
i would like to schedule my backup time. and immediately after backup i want to restore it to the database on other server, over writing existing data. what is the best way to do this???

thanks,
kishore

View 6 Replies View Related

SQL BAckup & REstore

Apr 20, 1999

I have a question related to SQL 6.5. We have a SMS 1.2 server which uses SQL 6.5. Two months ago, one of the NT admins did a NT backup of SMS database(sms.db) and then formatted the HD. Now, we need the SMS server back again. We installed the NT server, SMS server snd SQL server on that machine. The problem is, we now want the SQL server to recognize our SMS database (SMS.db file). We don't have any SQL backup of any database (that means, no copy of master database, no copy of other databases. IS THERE A WAY TO RECOVER SO THAT SQL SERVER RECPGNIZE THE SMS DATABASE(SMS.DB FILE)
Please help me out.
I would really appreciate that
Jazib Frahim

View 2 Replies View Related

Backup And Restore DTS

Sep 21, 2006

Does some one know how to back up a dts and then restore from a backup?

View 5 Replies View Related

Backup And Restore

Feb 2, 2004

I have a database xxxx on server a, I want to copy this DB to server b.How can I do this By back and restore.
WHere can take this back up?I want to take this to a personal folder and wanted to restore to server b from this folder.Is it possible?
Thanks.

View 2 Replies View Related

Backup And Restore

Apr 11, 2008

Hi all.,
How to take Backup for whole database and how to restore it.,
which would be the efficient way.,

View 3 Replies View Related