thanks to both of you for your reply.

may i have that document so, i may create jobs on both instances 🙂

ok i will try adding failover patner section.

thanks for your interest.

well, guys we do connection with database using ODBC Named DSN.

now Information file (ini) have information like this

CustomInit=Provider=MSDASQL; Driver={SQL Server}; Server=(local); Database=Ctrack; UID=fawwad; PWD=****;

should i add

Data...

ok so please tell me then what should i do ?

i dont have to keep any data on server A except the one that is in Differential backup.

if i go...

@ gilamonster

no i am talking abt A the live server.

it is clear to me regarding server B, how to proceeed.

i am asking CAN i Truncate some tables from server A...