December 24, 2008 at 10:25 am
Hi, I have database in readonly mode.I need to bring it to readwrite mode and take the backup.
I alter the database ALTER DATABASE TEST SET READ_WRITE.
but Iam getting the error:
Server: Msg 5063, Level 16, State 1, Line 1
Database 'test' is in warm standby. A warm-standby database is read-only.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Plz help me
December 24, 2008 at 10:47 am
What happens when you do a restore database Test with recovery?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 24, 2008 at 11:08 am
I do not have any backup for Test database. I need to take the backup now and delete it.
December 24, 2008 at 11:11 am
is this a secondary database in a log-shipping set up? If it has been restored with standby option, try
restore database test with recovery. --you dont need a backup to do this
warning: this will break log shipping
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply