Database become restricted user

Question

_{Friday, October 21, 2016 4:24 PM}

After restoring from backup the restored database become restricted User .

     

Now what is the solution ?

All replies (5)

_{Friday, October 21, 2016 4:31 PM ✅Answered}

Hi

Go to Select Database > Properties > Option >Restrict Access

Select Multiuse /Single user as your requirement

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

---

_{Friday, October 21, 2016 4:33 PM ✅Answered}

ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE mydatabase SET MULTI_USER

GO

Please click Mark As Answer if my post helped.

---

_{Friday, October 21, 2016 4:35 PM ✅Answered}

One think more is Restrict Access :-

Restricted_User means that database can be accessed by users with sysadmin and dbcreator server roles and db_owner database role.

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

---

_{Friday, October 21, 2016 4:38 PM}

I've got it thanks Guys .

---

_{Friday, October 21, 2016 5:47 PM}

Hi Tomas,

**exec sp_dboption 'database', 'single user', 'FALSE' **

Please click Mark As Answer if my post helped.