Alter database error

Question

Post reply

Alter database error

Arvind Mishra

SSC Enthusiast

Points: 140
More actions
July 19, 2005 at 8:15 am

#109819

I Have a problem:
to take transactional backup of sql sever2005 i need to put database into "
RECOVERY FULL" mode so i am using query in master database as:
--------------------------------------------------------
ALTER DATABASE <Your database name>
SET RECOVERY FULL
----------------------------------------------------
but I am getting the error

Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database 'ipr_qxcr239146' or the database does not exist.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
I am using windows authentication while connecting to SQL server..and database name is also correct in query.. not able to find where is the problem

Can anybody help me out
asap
Regards,
Arvind

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

maybe it's set to single or restricted user ?!

you could check with "select DATABASEPROPERTYEX('abs', 'useraccess')....

also, what about your permissions ?

**ASCII stupid question, get a stupid ANSI !!!**

noeld SSC Guru Points: 96590 More actions · Answer 2

the error message is pretty clear:

User does not have permission to alter database ...

Your login needs to have enough permitions to perform this task! (which it doesn't now )

* Noel

Arvind Mishra SSC Enthusiast Points: 140 More actions · Answer 3

select

DATABASEPROPERTYEX('ipr_qxcr239146', 'useraccess')

this query is returning NULL.

Actually I am using windows authentication to connect to SQL SERVER, so i thought Administrator is the superuser and it will have all the permissions.

looks like I have to set the permissions on my own..

Can you help me.. I am very new to SQL SERVER...

how to set permissions in SQL SERVER 2005

Regards,

Arvind

Arvind Mishra SSC Enthusiast Points: 140 More actions · Answer 4

Hello friend,

select DATABASEPROPERTYEX('ipr_qxcr239146', 'useraccess')