Backup and Copy folder in log shipping

Why do we need to create a backup folder and copy files folder during log shipping? During log shipping it creates a backup of the database and transactional log stored in the backup folder. Also the SQLDBPool_Logshipping_Secondary stores the transactional log.

Also during restore which folder is used to restore? Following the link: http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

asked Oct 30 '12 at 07:49 PM in Default

chitrarekha.saha
548 ● 1 ● 3 ● 17

@chitrarekha.saha - does this answer your question?

Nov 01 '12 at 08:03 PM Blackhawk-17

(comments are locked)

1 answer:

The backup folder needs to be accessible to all servers participating. You can use your default Backup folder but sharing that out may open a door to backups that shouldn't be accessible over the network.

Typically the Restore folder is located local to the secondary.

EDIT

As an aside, the instances participating are generally on different systems and not two instances on the same server. Hope this helps.

answered Oct 31 '12 at 12:11 PM

Blackhawk-17
10.5k ● 23 ● 29 ● 34

The copy file is located in \machine1SQLDBPool_Logshipping_Secondary and the Network path to backup folder is located in \machine1BackupTransactionallogbackupAbraHRMS_Live Do I store the copy and the backup folder in two separate locations and not on the same server?

Nov 14 '12 at 08:47 PM chitrarekha.saha

The Primary backs them up to one folder and the Secondary copies them to its own folder. The restores are done from the Secondary's folder.

Nov 14 '12 at 09:07 PM Blackhawk-17

Which one is the primary? machine1BackupTransactionallogbackup is the backup folder and machine1SQLDBPool_Logshipping_Secondary is the restore folder? Do I need both the folders in the secondary server?

Nov 14 '12 at 10:13 PM chitrarekha.saha

(comments are locked)