Hi,

Can you check the below.

master..xp_msver

sp_server_info

Jayakumar K.

Hi,

Check the following, Already our gurus were discussed same kind of issue, im not sure whether it will help or not!

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=113227

Jayakumar K.

Yes, as Steve stated, sp_help_revlogin will help you perfectly...

Hi Ian,

Based on the below article the above issue will occur if affinity mask enabled on the sql server. (Enabling affinity mask thru sp_configure is masking processors for process threads)

In order...

Steve im suspecting one more point here, the owner of the job is diffent login and accessing the job is differnt login (affected person). Will it be the cause of this...

Yes it is scheduled job. If i loggin to the server, i'm able to see the next run date and time, because i'm SA. But my customer is only DB...

Hi Adrian,

Before come to a resolution for that issue I switched from the company in the same month.

Appologies for the inconvenience caused...

warmest

Jay.

Hi,

As Balde said, in logshipping you can do LS for the whole database, you can not do it for table wise, for table wise you've to go for replication either...

Thanks for your reply,

I've checked the account, that is in Administrator group only, but still it is failing.

warmest

Jayakumar K.

This issue got resolved, the reason behind was, the linked server was running on the primary server where the Tlog backup generating for Logshipping. The Linked server is continuously trying...

You can use CLUSTER command from command line.

CLUSTER /CLUSTER:<ServerName) RES - this will give you all the resource detials in the cluster and CLUSTER /CLUSTER:<ServerName) NODE will give you list...

Robert you're correct, in this case we've to careful while deleting the same in Secondary and Monitoring servers. Bcaz those servers could be configured with some other servers. In Secondary Log_shipping_Plans...

Extremely sorry to all, Thanks Siva for your correction.

In Sec. Server : Lg_shipping_Plan_databases

Columns: Date_last_Copied,Date_Last_Loaded

In Monitoring Server : Log_shipping_Secondaries

Columns Last_copied_filename,Last_loaded_Filename

Last_Copied_Last_Updated

Last_Loaded_Last_Updated

The above columns are not updating, but the logshipping is in...

Hi,

For your previous question, you can use sysindexes  table also, inorder to count each rows in the table, directly we can read the no of records deails from this table.

Eg.

SELECT rowcnt...

Thanks for your immediate reply.

Jayakumar K