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/

more ▼

asked Oct 30, 2012 at 07:49 PM in Default

avatar image

686 38 48 56

@chitrarekha.saha - does this answer your question?

Nov 01, 2012 at 08:03 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.


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

more ▼

answered Oct 31, 2012 at 12:11 PM

avatar image

12.1k 30 36 42

The copy file is located in \\machine1\SQLDBPool_Logshipping_Secondary and the Network path to backup folder is located in \\machine1\Backup\Transactionallogbackup\AbraHRMS_Live Do I store the copy and the backup folder in two separate locations and not on the same server?

Nov 14, 2012 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, 2012 at 09:07 PM Blackhawk-17

Which one is the primary? \machine1\BackupTransactionallogbackup is the backup folder and \machine1\SQLDBPool_Logshipping_Secondary is the restore folder? Do I need both the folders in the secondary server?

Nov 14, 2012 at 10:13 PM chitrarekha.saha
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 30, 2012 at 07:49 PM

Seen: 1820 times

Last Updated: Nov 14, 2012 at 10:13 PM

Copyright 2018 Redgate Software. Privacy Policy