Ok that's a very well information. thanks!

Ok thanks for your inputs... i think same with tempdb will do go for raid1

ah ok... i'll try configure mirroring in a domain environment coz probably the problem is on the authentication. in workgroup we need to setup certificates unlike domain its built-in account.

probably i will try doing mirroring in a domain environment...

so mssql sp1 really doesn't work for mirroring?

i got it working....

what i did was i do manual restoration then after that i generated the script and put it into the mssql jobs.

thanks!

error:

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device 'D:ogcfinalogcfinalnew'. Operating system error 2(The system cannot find the file specified.).

Msg 3013, Level 16, State 1, Line 1

RESTORE FILELIST...

Hi appreciate your comments but the setup is in the same network and ip range. no firewall, no antivirus firewall, and i can telnet and ping the ip address, hostname,...

Error:

Ther server network address "TCP://svrbdb:5022" can not be reached or

does not exist. Check the network address nam and that ports for the local

and remote endpoints are operational. (Microsoft SQL Server,...