I'm using native backups.

george sibbald (9/22/2011)

---

thats a darn good question and I don't know why its been made harder to find out something important such as why a backup failed, all the info...

I'm not sure to what extent this will suit your needs, but here is a script that loops through a list of servers stored in a db table and executes...

Sorry, I don't have much new to report on this issue.

I...

A common cause that I have seen mentioned is bookmark lookups.

Process A is reading data from a non-clustered index, but needs to get to the base table to get the...

Glad it worked! I have been burned by this before... 😉

One more thing: get rid of the dashes in the "Data Source" name.

This might very well be the issue.

I have had this issue with the "-" characters before.

Best not...

Try this:

(ie. no space before "Password").

SJanki (9/21/2011)

---

Marios Philippopoulos (9/21/2011)

---

Do any of your data sources in the job (DataSources tab) use sql auth to connect to the instance? If yes, you will need to manually re-enter...

Do any of your data sources in the job (DataSources tab) use sql auth to connect to the instance? If yes, you will need to manually re-enter the passwords in...

uncle_boris (9/20/2011)

---

I have run the code below on the temp db.

SELECT * FROM sys.dm_io_virtual_file_stats(DB_ID(N'tempdb'),null);

The output shows it has had activity on both tempdb datafiles (ID 1 & 3)

Do you know...

I don't think it applies to...

uncle_boris (9/20/2011)

---

I already have two tempdb data files set up on the main server. Each on a separate disk and each the same size.

I have my doubts as to...

deleted

My 2 cents, based on how we do it in our shop.

We used to create one tempdb data file per cpu core, but later on I realized too many data...