I have got 2 servers.
A server which is a live one.
B server which is the failover server.
Every 15 mins my data gets transferred from A server to B server by a job.
I want to access data from B server by writting a query in Query Analyzer I recieve an error
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
This is something related with the server connections...
The job run2 every 15 mins so once the job has executed and if i execute the query in the A server I can access the data. But if its more than 10 mins then I cannot access the server.
Thanks in advance