I have removed the mirroring from a database (synchronous). When I look at
the target server, it still shows the database in Restoring mode and I'm not
able to do anything with it.

Why does the target server status show restoring when I have removed the
mirror from  the source?

Olav

Hi,

Just see if the below command will work out for you:-

RESTORE DATABASE dbname WITH RECOVERY

Thanks
Hari
SQL Server MVP

Show quoteHide quote

SQL Server 2005 fails to use index with simple query containing TO
SQL 2000 working slow on 2003 Server
SQL Servers 2000 and 2005
Initial size for a DB
Distributed query memory leak?
default database problem
Management of SQL2000 RS
DB Mail config
user does not have permission to perform this action
xp_sendmail