Solved

Sharepoint SQL Server Database (WSS_Logging) stuck in "restoring" mode

Posted on 2016-09-13
12
76 Views
Last Modified: 2016-09-14
I have noticed now for the last couple weeks when looking at SQL Server Management Studio that the WSS_Logging database is stuck in a "restoring" mode. How can I get this working normally again?
0
Comment
Question by:jb61264
  • 7
  • 5
12 Comments
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41796991
Are you using db Mirroring? If so, is this on the primary or secondary SQL server?

I have have had that happen before and although working with an expert dba all we could do was delete and restore. Luckily this was just a logging database and not a content db. I have had good luck (knock on wood) with this not happening on content databases.

Hope that helps...
0
 

Author Comment

by:jb61264
ID: 41797033
Not using db.Mirroring...in fact, I'm currently running sql server on the same sever (which I know is discouraged and is on my list to move to a different one soon)...after I figure this out.

I've read that wss_logging is for configuration information that feeds the central administration app with configuration "issues" so I wonder if it could just be "recreated"
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41797044
It provides diagnostic information, not so much configuration information. If it is stuck on restoring, it isn't working any way.

Your company may have an auditing and retention policy that may not make is possible just to delete without some type of approval.

The database WSS_Logging is the default name for the database used by the service application "Usage and Health Data Collection", in SharePoint 2010. (2013 is probably the same.) Before you do anything big with the database, like delete it, check with TechNet for the exact procedure.

Good luck...
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:jb61264
ID: 41797063
Thanks, no retention policies to worry about...do you think Sharepoint would recreate it if it were deleted? I checked and I do have a backup from back in August of that db, I'm thinking I could just restore with that copy as long as doing so doesn't mess anything up.
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41797077
You may not be able to delete it without stopping the service first. Currently I am not in a position to use anything but memory, so I can't say one way or the other exactly how to do it. Generally, service applications such as this can have their databases deleted and recreated. Worst case you would have to recreate the service application which would in turn recreate the database. But if you have access to Technet, it would be best to confirm all this there. Once I am back where I have references I will provide you with some definitive information, but that could be tomorrow at the earliest.

Maybe a real expert will add something definitive to this thread.

Have a good one...
0
 
LVL 17

Accepted Solution

by:
Walter Curtis earned 500 total points
ID: 41798113
I was able to confirm that deleting the service application "Usage and Health data collection" will also remove the database, in your case "WSS_Logging". Then you can recreate the service application and a new database will be created and should work fine.

Note- the service application name shown above is the out-of-the box name. You may have a different name, but probably not. As far as recreating the service app goes, I am sure powershell can be used, and I love powershell, but the Configuration Wizard found in Central Admin also creates the service application and database, although the db is created with a typical ugly GUID. Powershell probably allows you to define the name. (I was in my test farm so I don't care about GUID's)

As mentioned in this link, it is okay to delete the current database that is malfunctioning for you -

https://social.technet.microsoft.com/Forums/lync/en-US/3c80d63d-7422-4c2e-9cfb-001df1f5e7f7/wsslogging-stuck-in-restoringhow-do-i-fix-can-it-be-recreated?forum=sharepointgeneral

Good luck. Hope that helps...
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41798212
Thanks,  hope you got it working as it should again...
1
 

Author Comment

by:jb61264
ID: 41798249
I haven't used PowerShell much at all (and know I probably need to start learning it more)...from the Central Admin gui I was able to remove the Useage and Health Data Collection Service App, but I don't see an option for creating it in the "New" dropdown list.
0
 

Author Comment

by:jb61264
ID: 41798255
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41798260
You can recreate the Service Application using the configuration wizard. In central admin, it is in the left navigation, (quick launch navigation.) Once there, you will see the icon for Farm Configuration. Click on that, then you go to another page and you will see start the wizard, click on that.

You will then see the service apps that can be installed. Toward the bottom is the information about the "Usage and Health data collection" service app. The rest is straight forward.
0
 

Author Comment

by:jb61264
ID: 41798283
Got it! thanks! last question, in that configuration wizard there are a number of items checked where the checkbox is gray...does this indicate items that are already installed? and if so, should I uncheck everything except for the Usage and Health data collection service? I don't want to uninstall stuff that is already installed and its not clear from the wizard if this would uninstall things that were unchecked
0
 
LVL 17

Expert Comment

by:Walter Curtis
ID: 41798340
Yes, the greyed out boxes are service applications that are already provisioned (installed). You will not install them new if you leave them checked, I think you can't uncheck them, it is a read only box I think.

Good luck..
1

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

685 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