jwcolby
jwcolby at colbyconsulting.com
Fri Sep 18 07:38:55 CDT 2009
You can't open them in that state. I searched Google and found code to "restore them". Make sure you copy the file before doing so as the restore "fixes things", and the fix can in some cases trash the database. John W. Colby www.ColbyConsulting.com Arthur Fuller wrote: > I must have a more serious problem, since I can't even open the database(s) > in question. Fortunately it happened only to two relatively unimportant > databases. > Thanks, > Arthur > > On Fri, Sep 18, 2009 at 7:50 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > >> I have had this happen several times. In my case it usually means that the >> server lost power as it >> was writing to a table. In most cases that table was lost but the others >> were still there. >> >> John W. Colby >> www.ColbyConsulting.com >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >