SQL Server Performance

get error in step 2: restoring backup to secondary database...

Discussion in 'SQL Server 2005 Log Shipping' started by duoman, Mar 6, 2011.

  1. duoman New Member

    <p>&nbsp;I configurate Log Shipping in sql server 2k5 develope in workgroup network. when processing to step 2, get a error: cannot open backup device. please help me to solve this. I'm from Viet Nam so my english not good.</p><p><img src="http://www.mediafire.com/imageview.php?quickkey=0wooj7f0nsw5za1" mce_src="http://www.mediafire.com/imageview.php?quickkey=0wooj7f0nsw5za1">&nbsp;</p>
    duoman, Mar 6, 2011
    #2

  2. satya Moderator

    Welcome to the forums.
    As you are stating log shipping is configured between the instances, ensure that both PRIMARY and SECONDARY can connect to each other and from PRIMARY the folder where backups will be stored is visible & SQL service account consist necessary privileges.
    Refer to this http://www.sql-server-performance.c...0111:oukd4z_wcve&q=log shipping&cof=FORID:9#0 for more information on log shipping.
    Also I believe in a workgroup network ensure the referred path is shared between the computers.
    satya, Mar 7, 2011
    #3

Share This Page