Steve Jones - Editor (5/27/2010)

---

Why not? Just curious. If it really...

Well even if you only delete 1 week of data that equates to roughly 2% of the data in the table. With that much data, a scan will always...

nik27184 (5/25/2010)

---

No you get me wrong... let me tell you more clearly.

I have one db in sql 2008 but we need to send same to db to client as sql...

Open the application you are afraid to break and look up the source code or odbc connection.

Or if you are afraid to offend someone, change the password and tell them...

I've forwarded everything to the local admin. We're waiting on a test window to keep going. So far everything seems ok (we've moved backups earlier in the night...

Awesome guys. I'll let you know the outcome.

Trey Staker (5/13/2010)

---

So the backup log part finishes and it starts the file move? Turn on perfmon and watch and make sure there is disk i/o, network i/o. ...

Glad to see I'm not insane :w00t:.

Here's the...

Steve Jones - Editor (5/13/2010)

---

If the backup completed, I don't think it's SQL Server. How is the file moved? Could there be something in there waiting on a response somehow?...

That was the only job that hang.

Also in all logs, there's no notice that the agent was ever stopped / started other than the forced reboots we did on the...

I still need you guys... thread is almost 1 day old and no help so far (no offense to Bhuvnesh who gave it a shot).

Backup log succesful in 28 secs,...

Ok let's approach from this angle :

If it happens again what the heck can I do to figure out the problem?

Right now I'm thinking MS support. But is...

Nothing in windows event logs nor sql logs nor sql agents...

Everything is "A-OK" but the job never finished untill we did a forced shutdown... which then the agent stopped...

Luke L (5/11/2010)

---

Just out of curiosity and forgive me for asking the is it plugged in type of question, but did you make any changes to the report?

On...

Any workaround or bug on the connect site I can be reffered to?

Or plan D, any shortcut to delete all reports and redeploying everything at once?