Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Backup transactional log

Answered Backup transactional log

All Replies

  • Saturday, November 17, 2012 7:09 AM
     
     Answered
    Sign In to Vote
    2

    Hi,

    the folder path specified to backup the trn log files during setup of log shipping and the folder must be a shared folder on network btw both the servers......

    Regards, Ashish ----------------------------------------------------------- Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker..

     
  • Saturday, November 17, 2012 7:34 AM
     
     Answered
    Sign In to Vote
    1

    Hi Chitra

    If your are keeping your T-Log Files on Local Disk . It should be your Local Folder[ You have to Share this Folder with startup Account]

    In the Same way on Secondary server also you have create a share with startup account.

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

     
  • Saturday, November 17, 2012 10:32 PM
     
     Answered
    Sign In to Vote
    1

    Hi there,

    it doesn't matter which folder or server you use.

    It is matter that your SQL server agents sholud have full access to that folder.

    i will explain how it works.

    you will have primary database(PD), primary server agent(PSA), secondary database(SD), secondary server agent(SSA).

    You also need two folders for example primary folder(PF) and secondary folder (SF).

    when you set up the log shipping:

    PSA take transaction log back up and writes to primary folder(PF)

    SSA copies the file from PF and writes to SF. And then SSA restores the file to the secondary database(SD).

    So PSA should have write access to PF.

    and SSA should have read access on PF and Read/write access on SF.

    thats it. make sure you use full network path while setting up the process.

    thanks

    kumar