no

I didnt get you....They wanted to have backups of logshipping database aswell.

Is it ok to upgrade mirror server when the databases are in restoring state.

Why do i need failing over the databases ?

Is this the right approach if i follow...

These commands need to be apply at subscriber right then how can i restart SQL Server Agent.....Is this resolve this kind off issues.

What it mean by undistributed commands. If i...

okay

This was happen while we are installing cluster ...after installing\end of the installation caught an error and this leads to SQL Server agent got failed state.

we used domain account while...

Thanks friend...

may i know where i have done mistake

I returned following code...but it is not working fine

DECLARE @fileName VARCHAR(50)

DECLARE @name sysname

DECLARE @sqlcmd VARCHAR(1000)

SET @fileName = 'D:\data'

DECLARE table_Cursor CURSOR FOR

SELECT name FROM sys.objects where type='U';

OPEN table_Cursor;

FETCH NEXT FROM table_Cursor

into...

Finaly i understood that mirroring in failover clustering will possible between two clusters.

Reference doc:

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

I am Trying to create mirroring on different instance in Node N2 But it useses same Virtual Name

Thanks for all

Hi Gail ,

In my CASE, All SQL Sever engine versions are same (4 nodes are running with SP3) where as client tools on 2 Nodes are running with RTM...

Thanks...i will try

Ex :

SELECT i.name AS IndexName,SUM(s.used_page_count) * 8 AS IndexSizeKB

FROM sys.dm_db_partition_stats AS s JOIN sys.indexes AS i ON s.[object_id] = i.[object_id] AND s.index_id = i.index_id...

i understand the issue...now the problem is resloved....

Thanks for your guidence