Azure sql server

Alessio Cavalieri 5

Hi,

From today I have a azure sql database in read-only mode.

If I see on database properties option read-only is false

If I do this query

select name,user_access_desc, is_read_only from sys.databases

is_read_only is zero

but if i do any update I have this message

Failed to update database "dbname" because the database is read-only.

Any ideas?

thanks

Alessio

SSingh-MSFT 16,461 Reputation points Moderator

2023-12-01T10:33:27.95+00:00

Hi
Alessio Cavalieri,

Welcome to Microsoft Q&A forum.

As I understand, you could not find any result in select query for read only Azure SQL DB.

Could you please let us know if this newly created Database or has Tables and data in it?

If tables have data, could you please share the screenshot of the error.

Thanks
Alessio Cavalieri 5 Reputation points

2023-12-01T11:20:35.87+00:00

Hi ShaktiSingh,

thanks for reply.

I have open a ticket and they tell me that there is a problem with some customers.

Btw select query run and db is old with many tables and data

thanks

Your answer