Jump to content


Recommended Posts

I am trying to recover my SCCM 1806 site. I have a full site backup but it fails restoring the database.

I have rebuilt the server to the same version as before and then installed all the prerequisites including SQL and ADM wsus etc.  however it fails when restoring the database.  I have included the portion of the log file that is relevent(changing my site name and username) is there anything I may have got wrong is there another way of recovering?

Steps I have taken are

  1. selected "recover site"
  2. recovered the site server from my backup location
  3. recovered my database from my backup location
  4. entered serial number
  5. accept terms
  6. downloaded required files
  7. select installation folder
  8. Details of SQL are pre populated
  9. path to SQL server DATA file is prepopulated
  10. path to SQL server LOG file is prepopulated

At this point I am presented with the install settings, then it presents the prerequisite check and then begins the install where it fails with the errors seen on the log file attached

sccmlog.txt

Share this post


Link to post
Share on other sites

check the username/password specified in sql, that's where it's failing, see below snippet...

ERROR: Failed to restore databases.  $$<Configuration Manager Setup><12-13-2019 14:41:31.500+00><thread=3800 (0xED8)>
*** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sitename\user'.  

cheers

niall

Share this post


Link to post
Share on other sites

Thanks for the quick reply

The user that it is installing with is my domain admin account, and its using Windows Authentication would I have to enter the password in SQL elsewhere ?

Share this post


Link to post
Share on other sites

look in SQL under logins, see what logins are there, add your account as SQL SysAdmin if you are not sure what to do

Share this post


Link to post
Share on other sites

Thanks for that I have just gone into sql management studio and this is the permissions my account has

sql mapping.PNG

Share this post


Link to post
Share on other sites

what account was used before with the database mentioned ?

 

Quote

Cannot open database "cd_ste" requested by the login. The login failed.

 

Share this post


Link to post
Share on other sites

I have two accounts on SQL my admin account and a SCCM Admin account that was the account used, yet on the recovery it seems to use my admin account possibly because I am logged in as a domain admin not the sccm admin?  Should I be logged in as the sccm admin to recover the site?

Share this post


Link to post
Share on other sites

normally you should use service accounts, but in your case, your sccm login is probably what you need, try it...

Share this post


Link to post
Share on other sites

Ok I will try with that and get back to you

 

Thank you

Share this post


Link to post
Share on other sites

That has failed too, I am going to uninstall sql and go back through the steps to see if I might have missed something on the install

Share this post


Link to post
Share on other sites

That has failed too.  Is there a installing SCCM and then importing the .mdf and .ldf after?  

Share this post


Link to post
Share on other sites

are you failing with the same errors as before ?

Share this post


Link to post
Share on other sites

I have found this line 

ERROR: Failed to copy the file CM_site.mdf from source C:\Users\adminuser\Desktop\steBackup\SiteDBServer to destination \\SCCM-01.domain.local\C$\Program Files\Microsoft SQL Server\MSSQL12.SCCM2012\MSSQL\DATA. Error code: 59.  $$<Configuration Manager Setup><12-17-2019 13:21:04.446+00><thread=5040 (0x13B0)>

on inspection the folder is there 

 

Share this post


Link to post
Share on other sites

it's trying to copy a file (CM_site.mdf), not a folder. is the file in the source and target location ?

Share this post


Link to post
Share on other sites

Thanks for the reply.

 

I have just gone past the point it was failing on.  I moved the back up location to c:\ I also read somewhere else about having the local machine account as a local admin which I also did.

The recovery is still in progress but its looking better.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...