Thanks...

Step goes like this right:

1. Save in notepad sqlcmd sript as .bat file

2. After that sql script of backup_tlogs.sql i have to save in notepad OR i have to save in sql query analyzer ?

Also we have user database will it work after searching thru different instances ?

please reply......