SQL server only getting back online from recovery after restart(to correct issue)...it's not being restarted.

Thank you a lot.

I would think application DBA is more on development side.

In our industry solutions should really come under immense pressure.Business managers and users ask how long should we wait for the system to be up?Do I know? When I...

I was fortunate managed to get a recent backup it seems my database could be put bak online but i had managed to recover all the tables.

Yes I did put it from suspect mode.In order to run dbcc checkdb.

Normal restarting of the server.

Database is in emergency state.

Nince question,Thank you Steve.

Easy one for me .

Easy Mathematics.i like it.

A good and easy to guess question even to those who do not know.

Basically am running two statements:

1.alter databasename set partner off

2.restore databasename with recovery

It is the second statement that is failing,so are suggesting that after restore databasename with recovery gives an error...

Trying to make mirror the principal ,principal no longer available.

restore database clinic with recovery