Thanks for your Reply. I want to know how it will work.

Where DBCC or DMV will store. What its working.

But all instance is running good.. i am able to connect using different version of ssms tool (2014).Only prob is with default instance and ssms tool (2008 r2).

Why should i...

JUST FOR EXAMPLE - i have two SQL server instance A and B.

From B i have to check A Instance is up or not. If not it has to send...

JUST FOR EXAMPLE - i have two SQL server instance A and B.

From B i have to check A Instance is up or not. If not it has to send...

run below query

SET XACT_ABORT ON

GO

Hi...

Please let us know your prob has resolved or not

JUST I HAVE ONE DOUBT, IF I WILL NOT CREATE ANY CONFIG FILE SO I THINK NO USE OF MANUFAST FILE. WITH OUT CONFIG FILE ITS LIKE creating job use...

Yes.. you r correct.. I can open erroelog file.. But if my instance is down and its having 2 node cluster... how i will find in which node i have...

I got the result ..... i started the browser it started connecting..:laugh:

I think you haven taken the light speed backup.....

Thank you for reply......

It is possible if we write ant script .... If we can can you tell me how can i start:cool:

10:45 you started your sp for inserting and if your insert completed at 10.46 and then you started, Full backup - Backup file having all Transaction.

10:45 you started insert...

select serverproperty('computernamephysicalnetbios')

above command when you will run in sql server it will tell currently in which node cluster is running.

As per my knowege . you cant rename the server. If you want to rename you have to uninstall the instance then you have install with new name.

I am correcting my sentance -

Which are the table, sql server will create after log shipping setup and in which system database it will create?

Any thing it will do with...