lianvh (9/11/2012)

---

Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent...

Hi, did Brandie's link help?

Is that the only error message you got? From that it is very difficult to tell you something. I found something similar on connect, check the link "http://connect.microsoft.com/SQLServer/feedback/details/542754/net-runtime-errors-after-installing-sql-2008-sp1-update"

Have you check the permissions of the account that runs the SQL Server Agent as already suggested? In order to be sure it is a permission issue you can also...

Profiler will help you to accomplish what you mant, but it causes overhead on your Server. You may find this link interesting http://www.sqlskills.com/blogs/jonathan/category/Extended-Events.aspx

Perry Whittle (9/10/2012)

---

This is not completely true!

opc.three (9/9/2012)

---

If the sequence...

opc.three (9/9/2012)

---

This is moot because the OP got a solution, but since we're discussing...

Taking a FULL backup resets 'the differential base' unless taken with COPY_ONLY. NO_TRUNCATE may or may not...

navis59 (9/8/2012)

---

Environment: 64 bit version of SQL Server 2008 R2

Issue: When I tried to run a job which pulls about 25GB of data, it kept hanging. I...

SQL Mad Rafi (9/8/2012)

---

Hello Guys,

First, I thank many of you who directly or indirectly helped me...

Check this link for info about the log http://msdn.microsoft.com/en-us/library/ms143702.aspx

SQLCrazyCertified (9/8/2012)

---

SQL server 2008....stand alone.

Windows 2008 r2 SP1

I have been trying to install a SQL server default instance basically through out the day. 🙂

However, its failing to install all...

😉

I agree, but for that to work there must be no new full backup since Log Shipping was started....

jjohnsqldba (9/7/2012)

---

Thank you for your time and particiapation. i restore the full backup and went on with your advice. it is back on action now. Thank you one more...

opc.three (9/7/2012)

---

Ignacio A. Salom Rangel (9/7/2012)

---

opc.three (9/7/2012)

---

Taking a differential backup from the primary and restoring it to the secondary will re-establish your log chain, just remember to supply the proper...