might also be worth looking in the default trace to track some of those changes retrospectively

have you saved it off as an XDL or something?

Drop it in notepad or a internet browser and you should see the query there.

To add to other comments:

If the database you're backing up is spread over multiple volumes, you get a reader thread per volume. It reads into in memory buffer (the...

you want to take a full backup every hour? How come?! Are you aware of differential/tlog backups?

You can create a SQL Server job to execute any task every...

Hi,

On 2008 R2, when you put the MSDTC resource in the same cluster group as your SQL Server instance, it will (should) do the mapping automatically.

Hi,

So, are you saying that the services are running under a local machine account? If not, the SPN's registered against the machine are irrelevant. If the services are...

Hi,

Do you want to move it on the secondary, too? That'd be more problematic

I'd say no, it won't break it. Log shipping is just a backup, copy,...

please read: http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx

so do you have something like:

MSSQLSvc/server1.domain.com:1333

MSSQLSvc/server1.domain.com:INSTANCE1

MSSQLSvc/server2.domain.com:1334

MSSQLSvc/server2.domain.com:INSTANCE2

MSSQLSvc/server3.domain.com:1335

MSSQLSvc/server3.domain.com:INSTANCE3

MSSQLSvc/server4.domain.com:1336

MSSQLSvc/server4.domain.com:INSTANCE4

MSSQLSvc/CLUST1SQL.domain.com:1333

MSSQLSvc/CLUST2SQL.domain.com:1334

MSSQLSvc/CLUST3SQL.domain.com:1335

MSSQLSvc/CLUST4SQL.domain.com:1336

MSSQLSvc/CLUST1SQL.domain.com:INSTANCE1

MSSQLSvc/CLUST2SQL.domain.com:INSTANCE2

MSSQLSvc/CLUST3SQL.domain.com:INSTANCE3

MSSQLSvc/CLUST4SQL.domain.com:INSTANCE4

then, in AD, all these services are trusted for delegation?

Hi,

Are your SQL Server services running under a domain account?

If you have your SQL Services running under a domain account, you register the SPN's against those services. If the...

David.Poole (8/28/2013)

---

First, what the <insert your own expression here>?

My expression would be "Kalen Delaney".

Ada Lovelace - possibly the first ever computer programmer.

Grace Hopper "the mother of Cobol"

Frances Allen - Won...

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[myproc]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[myproc]

GO

Anti Virus maybe?

usually, the app developer will put a "failover partner" in the connection string for the application. When the primary goes offline, e.g. the server blows up, and the application...

What's your disk layout? If you can spread the files over multiple LUN's, then you should see an improvement in I/O performance. If you can use multiple filegroups,...