MSSQLTips

Hi all;

Yes did the famous start a restore on the production DB, and halted it immediately.  Now its stuck in the "loading" phase and the db is inaccessible.

So how does one stop that loading phase?  Don't mind if it does restore, as the restored data is only 6 hours older than current, but it seems stuck now?

Thanks, Steve

 Hi

 You have a couple of options.  

 I'd try 

restore database <your db> from disk='<your location>' with recovery

 Go it fixed.

 I just "deep-sixed" the database with Enterprise Mgr. as I have nightly backups of the db and translogs. Next restored the latest BAK and TRN for that db within Ent. Mgr.

Took about an hour, working now.  Thanks.

 Well, that was the other option which I call the "nuclear option". Good to hear you're all set.