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

Asked By juliomedina 10 points N/A Posted on - 08/10/2011

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.

• Status: Open
• Question Views: 1133
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By mathew202sss 0 points N/A #112956

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

 

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 

About mathew202sss

Questions
0

Answers
18

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 08/25/2011
• Question Category: MS SQL Server