Jeff Moden (7/16/2014)

---

What will be done with this daily report? Does it get emailed to a group of people or do they dip a common file somewhere? And,...

It is possible that the SAN has one (or more) large pools of storage - possibly with flash, SAS, and NL-SAS (SATA) drives in the same pool with a tiering...

Yes, you do.

http://www.sqlservercentral.com/Forums/Topic1410208-146-1.aspx

Thanks.

..and by that I mean: "thank you very much!"

Who are you and why are you so helpful???

Sorry - apparently posting from work is a problem.

This is the type of data that I'm working with:

USE TestDB

GO

CREATE TABLE testtable

(

ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

CompanyNumber nvarchar(50),

...

I appreciate that you have responded.

Can you please supply a reference to your assertion?

Thanks!

My understanding is that the service pack is installed on the active node - not 'each' node.

See Ken Davis post in this thread.

My question is whether a reboot is required...

spaghettidba (5/5/2014)

---

Ok, so no resource exhaustion event.

You should monitor the memory counters in Windows and see if they get too low.

If this is a SQL Server only box, you could...

It is SQL Server 2005 on Windows 2003 R2.

Sorry if I posted in the wrong place - I did not see a SQL 2005 High Availability topic, so...

Luis,

Thank you very much for the solution and for the reference.

..and that link is no longer valid, in 2014

Thanks, Lynn!

Thanks, Tiazi!

Thanks, SQL Server Central!

The google articles I see show how to recover to a point in time using backups. I am asking about a case where the transaction logs exist.

I thought that...

Much simpler fix for me.

Modify plan, edit backup task, don't change anything but select the OK button, save plan.

http://www.sqldbadiaries.com/2010/09/19/backup-job-failes-with-error-the-package-execution-returned-dtser_failure-1/

Look into sql server developer edition 2012...