GilaMonster (8/10/2011)

---

If the database was shut down cleanly (probably not) then SQL will recreate the log on startup.

If not, the database will come up in recovery_pending then you'll have to...

Great article by Paul. Good question, like to see more of these.

There should be some good tools available in codeplex site.

Have you tried searching there?

You might need to drop the existing database and then try...

you can try using SSIS

What is the db size?

You could check this link.

http://www.mssqltips.com/tip.asp?tip=2384

There are few more in the 'Next Steps' section, may be of use to you.

Check this.

http://stackoverflow.com/questions/200195/how-can-i-determine-the-status-of-a-job

Right click on job and stop it

Go to Job Activity monitor as see...

Try to create a linked server to that instance and then fetch data.

Brad, nice question. Need more from you on this topic.

By the by, your blog posts are cool. 🙂

Just type sqlwb on Start->Run and see if Management Studio comes up?

Great explanation Tom, Thank you.

Good one Grant, thanks for sharing.

Use this,

select name,log_reuse_wait_desc from sys.databases where name ='your db...