That's your problem. CXpacket is NOT a real wait. Remove the maxdop hint (not sure you can while it's running) and let that baby fly!

coronaride (7/29/2011)

---

After my linear guesstimates didn't work out, that's what I tried doing instead, really hoping to look like a genius. You're right, no so fun when they weren't...

Never heard of it :Whistling:

Well you could always say 3X the data = 5 to 8 fold. That way when it finishes earlier you look like a genius. If it goes...

No apologies necessary. I din't know that either ;-).

opc.three (7/29/2011)

---

Apparently 🙂

PS I have been called Crazy, but my nick is opc.three. SSCrazy is just...

Certainly HD or less likely RAM issue.

My guess is that it takes a certain "high" load to get to the broken serctors on the drives.

So ya run your disgnostics.

Bad band...

bharat sethi (7/29/2011)

---

Dear Lowell,

Thanks for the reply.

But, in OpenRowset again without LINKED Server we can't to this process. I need Query based solution to perform this process without using...

Steve Jones - SSC Editor (7/29/2011)

---

Ninja's_RGR'us (7/29/2011)

---

Do you guys(als) know a way to remove the prints from the backup / restore commands?

This is what I'd like to be gone from...

This creates your log table

USE [msdb]

GO

/****** Object: Table [dbo].[DBA_CheckDB] Script Date: 07/29/2011 11:50:01 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DBA_CheckDB](

[Error] [int] NULL,

[Level] [int] NULL,

[State] [int] NULL,

[MessageText]...

Do you guys(als) know a way to remove the prints from the backup / restore commands?

This is what I'd like to be gone from the output :

100 percent processed.

Processed...

DECLARE @cmd VARCHAR(1000)

SET @cmd = 'SELECT item, itemdesc, quantity INTO ' + @BackupDest + ' FROM item'

EXEC(@cmd)

So ballpark it at 2000 hours if you include all certs :w00t:.

Ok only 1999.99 hours to go on my end :w00t:

This is what Howard was reffering too.

http://msdn.microsoft.com/en-us/library/ms190730.aspx

Actually made me laugh...