Viewing 8 posts - 1 through 8 (of 8 total)
michaela (11/16/2007)
don't drop it yet; just run the WITH RECOVERY query from a new query window
I tried "RESTORE DATABASE MyDB WITH RECOVERY" and it worked!! :w00t: (I didn't put "database"...
November 16, 2007 at 5:34 pm
Thanks, I will use that when I'll look over the application that uses that database to figure out the problem.
November 16, 2007 at 5:14 pm
I tried that "RESTORE MyDB WITH RECOVERY" and I get this error:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'with'.
Msg 319, Level 15, State 1, Line...
November 16, 2007 at 5:06 pm
I will have to do that in the future; but I sure would like to know how come it grew from a few megs to 230GB in one day... (the...
November 16, 2007 at 5:03 pm
There's nothing accessing the database -- I even restarted the service. It took me close to two and half hours to restore it the first time -- can't remember if...
November 16, 2007 at 5:01 pm
OK, after about two hours it finished and it told me the restore was successful, but now when I try to access the database MS tells me the database is...
November 16, 2007 at 4:45 pm
I believe I've found the answer. It appears that beside a restart of the SQL service(s) I have to disable the fulltext index on the table and then re-enable it.
ALTER...
May 16, 2007 at 5:16 pm
Viewing 8 posts - 1 through 8 (of 8 total)