Thanks for your help..

Once final thing i want to add below query to above please suggest

SELECT servicename, service_account

FROM sys.dm_server_services

Thank you verymuch

I Have a query which will give the information like clustered,Computername,edition,version,hostname,servername,instancename,connedctingmode and service accounts information

--Select @@version,

select SERVERPROPERTY('IsClustered') As IsClustered,

--Serverproperty('BuildClrVersion') ...

Thanks for your information.

Is there any query to capture the information like Type of Backup, Mode of Backup information in SQL server

Thanks you very much it is working fine without an issue. Thanks to who developed such beautiful script.

Thanks for your information.

We have this script. when we are configuring the server first time this script is excellent to use. But for existing one if we are executing the...

Yes we have the admin access on that instance and we tried with SA account as well we were not able to connect

We added rules fopr TCP port and tried with multiple logins the same logins we can able to connect another server and Integration server in same server as well.

Also checked...

Thank you for your information. yes we have different mount points. in this case how can we add the file whether we need to break the mirroring or Pause the...

Thank you all for your suggestions I checked with all possibilities but doesn't help so I am going for additional space

Is there any other way to fix this issue because critical applications are running with HA on this server so we wont get the downtime.

Hi

It will give the information.On this case i need alert message through DB Mail

Thanks for your information Perry.

How can we modify the connection string for SQL2008. we have to change it Web Server config file or is there any option in Mirroring.

There are having two systems which are not in domain. so they re planning to restore the database from A server to B.

in A server they are using the external...