I just watched a video course by Paul Randall on performance tuning with wait stats (highly recommended course!) and he said that if you remove the PREEMPTIVE_OS_ you are left...

Thanks for the response!

I actually solved the problem with the following blog post:

http://consultingblogs.emc.com/jamiethomson/archive/2005/10/10/SSIS-Nugget_3A00_-Verify-a-data-source-before-using-it.aspx

I'll defo have a read through those stairways - some good moves in there...

This would be a good starting point:

http://technet.microsoft.com/en-us/library/bb964719.aspx

Phew - glad we got there - was starting to run out of ideas!

i don't think this makes a difference but is the compatibility level of the subscriber database set to 2005? I did a brief test on my local machine by...

can u post up the full version numbers of the publisher, distributor (if not a local) and the subscriber? i.e 11.0.3128 - can see what sp and cu you're...

do you have any 2005 instances in your environment? Could you have set up your subscription to the wrong server by mistake (have similar looking server/instance names).

I've...

you sure you're not running sql 2005?

select @@version on both instances return a 9.0by any chance?

2 second google search gave the link you need:

http://technet.microsoft.com/en-us/library/ms190447(v=SQL.105).aspx

This link gives you exactly what Gail is referring too - study it well, the example at the bottom shows you exactly...

Top link should help:

http://lmgtfy.com/?q=install+sql+failover+cluster+2008

Looking at the error you need to ensure that you have your dependencies set correctly in cluster manager.

Check the dependencies under the sql server service and ensure that your disks...

depends on how big your tables/indexes/stats are. For example I have an instance with 15 dbs on it, each db around 5-6gb in size and updating stats using sp_updatestats...

what's your max memory set to? How much memory in the server? what's your page life expectancy? are you having performance issues?

Just because memory utilization is high...

Posting the SQL would be a good start buddy. We might be able to make some suggestions if we can see what your are actually trying to do.

Could try this...

select * from msdb.dbo.log_shipping_primary_databases

http://technet.microsoft.com/en-us/library/ms190355.aspx