x

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 '12 at 07:49 PM in Default

chitrarekha.saha gravatar image

chitrarekha.saha
616 16 28 40

@chitrarekha.saha - does this answer your question?
Nov 01 '12 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.

EDIT


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 '12 at 12:11 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

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 '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? \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 '12 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x562
x61

asked: Oct 30 '12 at 07:49 PM

Seen: 797 times

Last Updated: Nov 14 '12 at 10:13 PM