+ Post New Thread
Results 1 to 2 of 2
Enterprise Software Thread, Restored SCCM2012 from snapshot, DB complaining (SQL 824), DBCC CHECKDB complaining in Technical; I have really fouled things up here I was looking at Office365 and installed DirSync on my SCCM server - ...
  1. #1

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    5,375
    Thank Post
    957
    Thanked 1,630 Times in 1,103 Posts
    Blog Entries
    47
    Rep Power
    711

    Unhappy Restored SCCM2012 from snapshot, DB complaining (SQL 824), DBCC CHECKDB complaining

    I have really fouled things up here

    I was looking at Office365 and installed DirSync on my SCCM server - thinking it had SQL already and is a secure server. Unfortunately I didn't read the documentation (I'd hit TechNet tab explosion hell) and so didn't realise I needed to run with a command line switch to get DirSync to use the existing SQL - instead it just went ahead and installed SQL2012. I didn't want that, so I uninstalled it all (SQL2012 as well), reinstalled on the existing DB, but SCCM had gone wrong and and and...

    So I decided to restore from backup.

    I have restored the server from DPM snapshots half a dozen times now. Every time I bring it back, it wants to run a chkdsk at boot. If I don't, the event log fills with complaints from NTFS about file structure. Once I do, the event log fills with complaints about SQL 824 events ("SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:59769; actual 0:0)" etc.).

    I try and run
    DBCC CheckDB ('CM_KGG') WITH NO_INFOMSGS, ALL_ERRORMSGS
    and get
    Msg 8921, Level 16, State 1, Line 1
    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

    in reply. TempDB has 8.875MB free out of 17.1875MB, but my understanding is it should grow automatically anyway.

    The server is virtual, so I don't see how it can be hardware failure causing these problems. SCCM2012 still runs despite all these errors in the logs. This happens with multiple backups.

    What the bloody hell can I do to make it all ok again? Can I get SQL to repair the DB or is a system table too thoroughly borked? Can I rebuild the DB in SCCM?

    /feeling really, really stupid atm

  2. #2

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    5,375
    Thank Post
    957
    Thanked 1,630 Times in 1,103 Posts
    Blog Entries
    47
    Rep Power
    711
    Thank the gods, I found a backup that didn't have borked pages in the MDF file and have restored that (along with relevant LDF log file) and everything is up and running. I now need to investigate DPM and make sure it's backups are not crap for everything else...

    Lesson learnt: TEST YOUR BLOODY BACKUPS (and don't trust MS installers to use any intelligence or ask you questions that you need asking)



SHARE:
+ Post New Thread

Similar Threads

  1. Restore corrucpt registry or restore server from a USB HDD image?
    By ReverentCreature in forum Windows Server 2008 R2
    Replies: 0
    Last Post: 6th December 2012, 10:54 AM
  2. Replies: 4
    Last Post: 6th January 2010, 12:59 PM
  3. Restoring shares from backup
    By synaesthesia in forum Windows
    Replies: 0
    Last Post: 15th August 2009, 11:33 AM
  4. Replies: 19
    Last Post: 8th January 2007, 10:14 PM
  5. Restoring data from a corrupt sd card
    By timbo343 in forum Windows
    Replies: 4
    Last Post: 15th June 2006, 10:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •