Hi Robert,

From the Secondary Server , i can access the shared folder \\Primary Server\Backup but i have not setup a trust relationship with the 2 domains. I did not want to.

That's Strange Robert when i used the queries it is not showing me any result,except for the last one

select@@servername it is showing me name of the secondary server with the instance or probably the Database name coz the instance and the DB name is the same.

I have set the sa password same on both the servers.I have created same local users on both the servers.

Thanks.

Liju