January 27, 2006 at 8:34 am
In my development box, Last night one develpor executed one SP which does some insert, delete and update and select and run for the whole night, when I came in morning it was still running so i killed the jon and saw log file size is grown up.
When I try to oepn DB I cannot its taking longer to open. so I stopped the server and started back but its still taking longer any idea what should I do?
And If able to open Enterprice manager, what shall I do shall I drop that DB?
January 27, 2006 at 9:14 am
Its working now....but it took longer to open
Thanks
January 27, 2006 at 11:53 am
Why do you want to drop the database?
EM might have taken longer to open because when you stopped the process it had to rollback the transaction. The amount of activity might have been too much for your development computer.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply