Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Sql server log shipping

Răspuns Sql server log shipping

  • Friday, November 16, 2012 3:43 PM
     
     
    Sign In to Vote
    0
    Why do we need to create a Transactional Log Backup Settings as well as Copy File folder during log shipping.

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

    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?
     

All Replies

  • Friday, November 16, 2012 3:47 PM
     
     
    Sign In to Vote
    0

    As per design, Microsoft allows you to mention2 shared folder one at source server & second at destination server. And copy job will copy the backup files from one shared to second.

    If both shared folders are on one server, you have no need to copy backup files 2 times. You can mention same shared folders at both locations.

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

     
  • Friday, November 16, 2012 4:37 PM
     
     
    Sign In to Vote
    0

    As suggested I have both shared folder on one server(server1) and I named them as SQLDBPool_Logshipping_Secondary and Backup\Transactionallogbackup\AbraHRMS_Live. I have the Transactional Logbackup setting stored in Backup\Transactionallogbackup\AbraHRMS_Live Do I have to create a separate location for copy files?

    • Edited by ChitraSaha Friday, November 16, 2012 5:04 PM
    •  
     
  • Wednesday, November 21, 2012 12:49 AM
     
     Answered
    Sign In to Vote
    0
    you can create on shared folder on your sencondary database machine. If you do not want or your both primary & secondary on same machine (may for testing purpose) then you can mention same backup folder at both location, you have no need to create 2 folder on same machine.

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.