Solved

Restore SCCM problems with sql .bak??

Posted on 2009-05-07
3
770 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
can i use dropbox on a server used as a local share 8 133
accessing the windows\csc folder 5 145
tsadmin.msc on WIndows 2012 R2 4 298
Shared files and folders migration 2 30
This is my 3rd article on SCCM in recent weeks, the 1st (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html) dealing with installat…
Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 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