The network path for copy file is located in \machine1\SQLDBPool_Logshipping_Secondary and the Network path to backup folder is located in \machine1\BackupTransactionallogbackupAbraHRMS_Live Do I store the copy and the backup folder in two separate locations and not on the same server?
Are these the folders for the local copy of the backup then the copy to the remote server for the restore? You usually wouldn't want to backup or restore to/from a remote server.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
I have created both the folder on the secondary server from the primary server. Anyway my question is do I need to create the backup Transactional log setting as well as the SQLDBPool_logshipping_Secondary in the same server.