Feature: Database Engine Services

Status: Failed: see logs for details

Feature: SQL Server Replication

Status: Failed: see logs for details

Feature: Full-Text Search

Status: Failed: see logs for...

If you have required only columns information then you can use this also

SET FMTONLY ON

GO

Select * from [linkedServer].[databaseName].[schema].[tableName]

INSERT INTO TAB1 values('Jahanzaib','Pakistan')

GO 400000

INSERT INTO TAB1 values('Colin Roberts','UK')

GO 400000

INSERT INTO TAB1 values('Binary','South Africa')

GO 100000

INSERT INTO TAB1 values('SuperMan','USA')

GO 100000

that is an example to load the dummy data just execute it...

Check the properties of the Linked Server as mentioned by the Deepak and shown in the attachment

Excluding database files from the anti-virus is common others stuff is to restrict extra processes ,application,access on database files folder to other users and ports with the help of anti-virus...

If you can use Replication then go to this because linked server have performance issue always because network will involve and you will fetch whole data from the Server A...

.net framework will be install with the SQL Server 2008 R2 setup,you have to install VS 2008 SP1 if available on this server and update windows Installer 4.5

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

the obvious danger of adding all those certifications after your signature is you put yourself up for a fall.. I can only assume you've never used a log shipped standby...

Microsoft support Active/Active Cluster but what does it mean active/active,its for multiple instance on a cluster and there is no any type of load balancing

owner of the job ?

job history error ?

you can create the ODBC DSN connection and then create a linked Server with it

check the information regarding PROTOCOLS

http://aureus-salah.com/2010/02/13/sql-server-protocols/

http://aureus-salah.com/2011/05/10/sql-server-logshipping-issue/

Editor: Post removed as it promotes copyright infringement.

Apply first the Service Pack 2 if this is not R2 and apply CU 7 if this is R2,this problem has resolved in these updates

SQL Server 2008 R2 Service Pack...

There is no any term like Database Partitioning ,the correct term is Table partitioning and Index partitioning

http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

visit on the link for further clarification