I am a beginner SQL user, as the company laid off the IT guy and I am stuck with this. ÃÂ So I really need some help on this one. ÃÂ Any ideas would be appreciated.
I was doing a merge join command to put data from one database to another. ÃÂ These are 60GB databases with valuable data. ÃÂ Halfway through I was told by client to just stop the query. ÃÂ I did this but it left the good database with a large 80GB log file.
When I rebooted the machine the recovery of this database took 5-10 minutes... ÃÂ Thus the SQL Agent disabled itself waiting for recovery. ÃÂ After recovery was 100% complete with no errors SQL Agent will not restart. ÃÂ I can do a force turn on using a "1" statement, but the SQL Agent log file says it is still waiting for recovery.
In any event, I cannot detach the database because it says 1 user connected. ÃÂ I cannot backup, drop, etc... ÃÂ I saw in one forum a guy said to turn service off, copy database to a new location, turn service back on, delete the database, attach copied database... ÃÂ But I am a little worried about deleting.
Once again - I am a SQL newbie and really need a pointer on this one. ÃÂ I need to free this database and get a it back to a normal sized log file.
View Complete Post