April 21, 2009 at 12:14 am
Hi,
i've prepared a database for log shipping. But it is showing standby/read-only mode for that database.
I just want remove that mode. I have executed alter command.
ALTER DATABASE FTDTVer5 SET READ_WRITE
Database 'FTDT' is in warm standby. A warm-standby database is read-only.
ALTER DATABASE statement failed.
Please help me regarding this.
🙂
April 21, 2009 at 1:28 am
If you're database is logshipped it's in a restore state. Inorder to make ik available read-write you need to exeute this:
RESTORE DATABASE database_name WITH RECOVERY
[font="Verdana"]Markus Bohse[/font]
April 21, 2009 at 4:52 pm
vrabhadram (4/21/2009)
Hi,i've prepared a database for log shipping. But it is showing standby/read-only mode for that database.
I just want remove that mode. I have executed alter command.
ALTER DATABASE FTDTVer5 SET READ_WRITE
Database 'FTDT' is in warm standby. A warm-standby database is read-only.
ALTER DATABASE statement failed.
Please help me regarding this.
No you would not be able to do it. Secondary server in Logshipping is either in Recovery state or in Standby state(which is a read only), Users can connect to this secondary database when it is in Standby state but only as a Read only, they would not be able to write on the secondary server.
What are your requirements?
April 21, 2009 at 4:58 pm
vrabhadram (4/21/2009)
Hi,i've prepared a database for log shipping. But it is showing standby/read-only mode for that database.
I just want remove that mode. I have executed alter command.
ALTER DATABASE FTDTVer5 SET READ_WRITE
Database 'FTDT' is in warm standby. A warm-standby database is read-only.
ALTER DATABASE statement failed.
Please help me regarding this.
Logshipped configured database, on secondary server, is always in restoration state or in standby state (database is accessible in readonly mode).
If the database is restored with recovery, then transaction log backups cann't be applied on secondary server.
What are your exact requirments?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply