Instead of waiting for 19 hrs, if downtime was available, couldnt you restart sql?...wouldn't it kill that process?

Not exactly sure if its the right approach.

How about changing the recovery mode to bulk before executing your query?

That way it will be minimally logged and your ldf file won't grow that high?

Just a thought.

Yes, that's my understanding. Index is useless since table scan is faster...in this particular scenario.

Hi, just curious, how big is this table?

If the table is very small, table scan is sometimes faster than seek...so, that's why the fragmentation is getting high again.

Experts, correct me...

Through sql config mgr. I see the new accts reflected...and 2(SQL Browser & Full text search) out of the 4 services running fine with new acct.

I found this solutions and tried it, but still didn't work. This looks like exactly the error as I have.

http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/mssqlserveradmin/fixing-a-sql-server-could/

I was asked to automate a lot of our tasks we do normally.

I deal with a lot of DR activities....like mirroring/Logshipping failover/failback.

Also stopping and starting SQL services.....I know SQL stops...

Hi Gail, yes, I looked at the error log and found it will take about 33000 seconds to recover the database....therefore my DR failed and we had to fail back...

The query is still running, about 3 hours now.

Is there anyway to find the ETA for this?

Please advise as I am stuck with no options at the moment.

Hi Gail, thanks for your reply.

Now, I see the database (In Recovery) and the query is still executing.

I should still wait and let the query complete?

log file" use more than 70% of the disk space.

Which scenario do you recommend?

1- Backup the database, backup the transaction log to a new disk, shrink the transaction log file,...

Yup, I need to speak to Windows/SAN team....thanks for your suggestions.

Perry Whittle (1/15/2014)

---

SQLisAwE5OmE (1/15/2014)

---

Perry Whittle (1/15/2014)

---

SQLisAwE5OmE (1/15/2014)

---

I have 2 node, active/active cluster with 10 instances on it.

I have to do a DR test(SRDF), however, one of the application/instance do not...

Perry Whittle (1/15/2014)

---

SQLisAwE5OmE (1/15/2014)

---

I have 2 node, active/active cluster with 10 instances on it.

I have to do a DR test(SRDF), however, one of the application/instance do not want to move...

Aatish Patel (1/11/2014)

---

I have SQL 2008 database and have configured mirroring on that database. Now a huge tables with billions rows needs to be truncated and then need to...