Recovery state of principal database after failover

Hi everyone,

I have set up a mirror configuration with 2 databases and a witness.
When I test the fail over by removing the ethernet connection of the
principal database server, the mirror database becomes the principal
database. But because the database is still in the recovery mode, the
applications that were connected to the first principal database are not
able to connect to the new principal database. Did i do something wrong
or is there a way that the database can leave the recovery state when it
is the principal database?

Thanks, Remco


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Slightly OT: Database for embedded loggers
    ... >I have a logging product where the data is downloaded serially over an ... >RS232 or ethernet connection. ... >software to poll for data and put it in the database, ... I have read Borland Interbase ...
    (comp.arch.embedded)
  • Re: Slightly OT: Database for embedded loggers
    ... > RS232 or ethernet connection. ... Typically multiple units are connected on ... > data storage, but I'm not sure where to start. ... > software to poll for data and put it in the database, ...
    (comp.arch.embedded)
  • Slightly OT: Database for embedded loggers
    ... I have a logging product where the data is downloaded serially over an RS232 or ethernet connection. ... Typically multiple units are connected on the same network and polled regularly for data by the customer's system. ... My thoughts are to install an SQL compatible database for the data storage, write a custom piece of software to poll for data and put it in the database, and a web page with scripting for the user to access the data. ...
    (comp.arch.embedded)
  • Re: What is prev1.edb and why is it 15 GB?
    ... > Whereas the database was new and everything was available> to rebuild the database we moved all the database and log> files into a temporary location. ... Had to manually mount the mail store so it> created a new database. ... Only> problem we have is when starting Outlook on the clients> we get a message stating Exchange is currently in> recovery mode. ... The choices are connect, work offline and> cancel. ...
    (microsoft.public.windows.server.sbs)
  • Re: ntbackup & MS SQL 2k SP3 on Server 2003
    ... > dual Xeon Dell server that came preinstalled with Server 2003. ... Further tests showed that the error only appears when backing up from a volume on which there a database files of a database in Full Recovery mode. ... So it is not a problem if SQL Server is installed and running - you simply cannot backup databases in Full Recovery mode using a file backup. ...
    (NT-Bugtraq)