If the transactional log is happening in server A, then server B SQL server agent has to copy this file from server A to B.

send your mail id.

Regards,

Ratnesh

but database is giving error is related to backup.

delete the created database for log shipping(if created)delete the backup and transaction log backup from backup folder.

Create database Test on primary server...

use master

restore database database name with recovery

go

execute this, database will come in recovery mode. I didn't understand why you are taking backup of secondary database if i am right. Primary...

Yes, small correction either stand by or No Recovery mode. In stand by mode you can use database for reporting puerpose. Other security things you have to enable when familiar...

Now i understood the probleom, Database is not in Standby mode or No recovery mode.

To resolve this either you have to take a fresh backup and restore in stand by...

Hi, Can you let me know the entire process that you have done for setting log shipping in points. i will correct the process.

1. Identify the primary and secondary server.

2....

Path is ok access control is issue, the credential which is running SQL server Agent on secondary server should have access on primary server folder so it can copy transactional...

Transaction log is not getting copied to the secondary server so restore is not happening. Check copy schedule job history on secondary and make sure its happen successfully. You can...