Solved

Restore SCCM problems with sql .bak??

Posted on 2009-05-07
3
765 Views
Last Modified: 2013-11-21
We had our Primary site server go down, and we lost the data base files that the sccm backup wizard created. We are able to get the .bak file from sql and still have the system state backup is there anyway we can recover using the sql backup and then just the sccm system state? or do we need to start over
0
Comment
Question by:darklord12
3 Comments
 
LVL 6

Expert Comment

by:question
ID: 24332179
create a test env and restore the system state and connect the same to the sql db backed up?

just out of curiosity:-- Did the sql server fail at the same time sccm server failed. Was db and sccm on same server?
  Btw.. if you have the system state back up does it have the full backup of the installed files as well or is it just the windows system state.

If its just the windows system state i am quite sure the restoration is not possible coz all the settings are lost.

-Question
0
 
LVL 8

Accepted Solution

by:
U_Mansson earned 500 total points
ID: 24369688
Hi

Question is right, you need the files to restore you site. It is not enough with the db and system state.

Regards

Ulf M.
0
 
LVL 8

Expert Comment

by:schriste
ID: 24387440
Last time this happened I was able to restore the DB using the .bak file however; you will run into other issues and waist more time trying to recover the site. You would need to start over.

-Cheers-
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack.  My needle was an anti-virus version causing problems with my Exchange server. I have an HP DL350 with Windows Server 2008 Stand…
On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now