sql2000 after suspect it is showing (recovering\suspect)
Posted on 2004-03-31
My database name is allen
today i saw mydatabase name : allen(suspect)
From error messages I understood that it is suspected because of not enough space.
I created more spaces.
With query analyzer, I changed sp_resetstatus
after restarting sql, not it is showing
Last two hours, it is showing like this.
mt database size is 10 gb.
what must i do?