February 16, 2025 at 4:39 pm
I am a software developer using MS SQL server as my database.
I have setup transactional replication between two servers (A as publisher and B as subscriber). My application is running on server A. This has been running smoothly until my server A crushed. A new server has been provisioned for data to be restored for application to use. After taking a backup from server B and restoring to new server, I noticed database is read only. Anytime I try inserting data into a table, it fails, with a message of violating primary key constraint. How do I make the database writable on this new server
February 17, 2025 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 24, 2025 at 9:42 pm
Did you try right clicking on the database, go to options, and set the Read-Only to False?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply