I don´t have access to data base

Question

hi,

I'm trying to get access with "user b" to a Sql Server Data Base whitch it was created by "user a".

I got this error:

I otrher words i mean i cannot access to "1RQ_BPCSQL1" Data Base whitch was created by other person with another Windows session..

Where i have to change the right permittion to be able to use that Data Base??

Thanks.

Rajeesh Menoth · Answer

Hi, Please check the following article. Reference : https://blog.sqlauthority.com/2011/12/27/sql-server-target-recovery-time-of-a-database-advance-option-in-sql-server-2012/

Mohsin Arif · Answer

hi you see in folders there is security folder in which all users and permissions are exits

Ramon Quintana · Answer

Hi, Amit. The Problem is just that i can not to open "the Properties command" due to lack of permittion to do that, but i Run SQL SEVER as Administrador and then i can open the whole Data Base and all of her components, Thank for your support likely.. Cheers to all of u.

Amit Kumar · Answer

Hi, you cansolve it very way step by step. They are as given below.Using SQL Server Management Studio To change the target recovery timeIn Object Explorer, connect to an instance of the SQL Server Database Engine, and expand that instance.Right-click the database you want to change, and click the Properties command.In the Database Properties dialog box, click the Options page.In the Recovery panel, in the Target Recovery Time (Seconds) field, specify the number of seconds that you want as the upper-bound on the recovery time for this database.For more details go through the below links:https://docs.microsoft.com/en-us/sql/relational-databases/logs/change-the-target-recovery-time-of-a-database-sql-server?view=sql-server-2017 https://www.google.com/amp/s/blog.sqlauthority.com/2011/12/27/sql-server-target-recovery-time-of-a-database-advance-option-in-sql-server-2012/amp/