July 16, 2003 at 12:32 am
Hi
I have made a backup of database with replication and restored on to another server with warm standby. However I am now unable to change the state of the database,restore over it, detach or remove replication.
Any ideas?
July 16, 2003 at 4:12 pm
I restore frequently on the same server with different name, haven't had problems. Is the db accessible at least?
Andy
July 16, 2003 at 4:56 pm
The DB is read only. However replication is preventing me from
restoring a full standby, applying differentials or applying alter database to make it read/write. Also I am unable to stop replication because the database is read only and so cannot change the replication settings.
Edited by - growl on 07/17/2003 12:13:11 AM
July 17, 2003 at 4:53 am
Read only on purpose? Have you tried sp_dboption to remove the read only setting? Also the published attribute.
Andy
July 17, 2003 at 9:43 pm
Hi Andy thanks but I get the following message
Server: Msg 5063, Level 16, State 1, Line 1
Database 'nab_pcs' is in warm standby. A warm-standby database is read-only.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
sp_dboption command failed.
July 18, 2003 at 4:08 am
Try this:
RESTORE DATABASE mydb
WITH RECOVERY
Andy
July 21, 2003 at 6:25 pm
Hi Andy I am unable to use this command as I do not have exclusive access to the database.
I have tried setting single user. But still the database is locked?
Can the replication settings be causing this?
July 22, 2003 at 9:51 am
Should not be replication. Query sysprocesses to see anything connected to that db.
Andy
July 23, 2003 at 2:08 am
Hi Andy,
I checked the dbid by looking in sysdatabases and did
select * from sysprocesses where dbid = '30'
Nothing.
July 23, 2003 at 7:07 am
What about setting Category field for this database to 0 in master..sysdatabases table?
This will fool the server, so it will think, that database is not for replication.
/* did this, when moving logs for dbs with replication to another disk */
July 23, 2003 at 4:15 pm
That's a nice trick, wish I had known it a few months earlier!
Andy
July 27, 2003 at 8:54 pm
Thanks heaps.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply