I'm running a Powershell Script to configure search initially on one server. During the process I receive an error that it can not find the Usage and Health database. I used pre-created databases for Usage and Health following this article: http://blogs.msdn.com/b/sowmyancs/archive/2012/12/14/considerations-while-provisioning-the-service-application-using-pre-created-databases.aspx and Search is looking for the temporary database which I deleted. Usage and Health appears to be running fine and uses the correct database. How can I update Search or SP2013 to use the correct database and not the temporary database during the provision process?  I have run Get-SPDatabase and the temporary database is not listed. The following is the Powershell Error:

New-SPEnterpriseSearchServiceApplication : A database exception occurred when creating Search Application: Cannot open database 
"WSS_Usage_ToDelete01" requested by the login. The login failed.

The original Powershell script I am using is from: http://balamurugankailasam.blogspot.com/2013/04/sharepoint-2013-create-and-configure.html

Thank You in Advance.

Hi,

If my understanding is correct,  you created a new Search Service application on your server again after deleting WSS_Usage_ToDelete01, then got the error message.

Could  you create a Search Service Application in CA?

Could you see the search service application you have created in SharePoint Central Administrator?

If yes, please delete it.

Or you can use SharePoint 2010 Management Shell to check if the search service application exists. If it exists, please delete it. You can do as here.

Then  you can try to create a new Search Service Application again in CA or by using PowerShell.

More  information, please refer to the link below.

http://www.powershellmagazine.com/2013/04/29/creating-and-configuring-a-sharepoint-2013-search-service-application/

I  hope this helps.

Thanks