Log Shipping for multiple databases

Hello

we have SQL instance which contains databases (A, B, C...). When ever i configured LS with Standby option, and i want complete restore of database A (Primary) to stand by A (Secondary), then logs will always going to restore...

but SQL server is taking a copy of the Backup like "GJ_Temp_data, GJ_Temp_log" as the default file names, for restore the DB Backups.

if i want to set up for the database B, it is taking "GJ_Temp_data, GJ_Temp_log" again for the database B, and giving error as "the files are already in use".

If i script the Log shipping setup while enabling for Database A, and make sure that i will enabling it for remaining databases B, C, D..

Please advice, and give us best experienceS for enabling LS FOR Multiple databases on the single SQL Instance.

Thanks in advance.

Pls perform the below steps I assume there are 2 sql servers namely Sql1 and Sql2

1. Take full backup in Sql1 of database A and copy it to shared folder in Sql2 and restore with standby option

2. Take full backup in Sql1 of database B and copy it to shared folder in Sql2 and restore with standby option

3. Start the log backups,copy and restore jobs in principal and secondary servers for both the databases

Performing log shipping in a single sql instance will not server the purpose of log shipping as LS is a high availability solution and in your case if the single instance which holds both the primary and secondary db is down you cannot have a DR solution as a backup to your production db !

Thanxx

Deepak