ericjorg (4/9/2013)
GilaMonster (4/9/2013)
Good way to destroy a database...http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
Yes, that is exactly right. In my case, this was a test database and the logfile was created in a different version of SQL server, so it was safe to wipe it out.
Very exceptional situation then. Normally deleting the log of a database that's in recovery will make the database recovery_pending, deleting the log of a database that's recovery pending will result in it still being in the recovery pending state.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability