What DB's to backup for a restore

Question

The SQLServer that supports SharePoint is corrupted. The DBs are OK.  What DB's do i need to backup so I can delete & then rebuild the VM SQLServer?

Thanks

---

John Lenz

Answer 1

You need to restore all the databases, and on SharePoint server create alias and point to the new Sql server. 

---

Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -Waqas Sarwar(MVP) Blog: http://krossfarm.com

Answer 2

Hi John,

Is there any update?

I agree with Sarvar's reply, you can also check the posts below to get more information about rebuild a SharePoint farm through existing databases.

https://sharepoint.stackexchange.com/questions/22944/configure-a-new-sharepoint-install-with-existing-databases

https://docs.microsoft.com/en-us/sharepoint/administration/restore-a-farm#using-sql-server-tools-to-restore-a-farm

If the post helps you, you can mark it as answer.

Best regards,

Grace Wang

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

Answer 3

Hi

You can rebuild your new farm at first.

Then create another web application.

Backup and restore WSS_Content_xxxx Database to new farm.

Mount the DB to new web application by powershell.

Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL> [-Updateuserexperience]

Backup the files in IIS path such as below path:

C:\inetpub\wwwroot\wss\VirtualDirectories\80

Deploy all solution into new farm.

I think your site will run normally.

---

Please remember to mark the replies as answers if they helped.

Linyu - SharePoint Engineer

Blog: http://blog.csdn.net/linyustar

GitHub: https://github.com/linyus

QQ Group: 72637444

Answer 4

I am in a GoLive at a client site for most of the week. I have rebuilt the Server and next have to install SQLServer2012. I'll let you know when the SQLServer is rebuilt.

Thanks for your patience

---

John Lenz

Answer 5

Hi John,

Looking forward to your feedback.

Have a nice day!

Best regards,

Grace Wang

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

Answer 6

Here is where I am.

rebuilt the serer2012R2 standard as a Hyper-V system, Same computers name & IP address. 

Installed SQLServer 2012SP1 and named the server & instance the same as before.

re-loaded all the DBs from Nova Backup.

Tailored SQL per SharePoint tuning guide.

Brought SharePoint up but does not connect to SQLServer. Of course SID is different. Networking is both TCP & named pipes.

How do I re-connect SharePoint to its SQL server?

---

John Lenz