User goes missing when I restore a database in MS SQL Server

Asked By 10 points N/A Posted on -
qa-featured

I am setting up a disaster recovery box for the production website. For this, I took a backup of the production MS SQL database and restored it into the DR box. When I run the application, I get an access denied message. I checked the database and I found that the user mapping is gone! I want to restore it.

SHARE
Answered By 0 points N/A #112956

User goes missing when I restore a database in MS SQL Server

qa-featured

 

Hi Julio,

 

Yes you can restore you missing application using the search engine in your system. there are a lot of ways you can restore your file. But it will depend on how you did it in your file. Try to check your recycle bin if the file was there and it is easy to restore it. Or if the was not there you can try to find using the search engine as I’ve said before. Click start button and first line you will find the search engine and type the name of the file you delete or missing. Hope it would help you. Thanks 

Related Questions