get error in step 2: restoring backup to secondary database… | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
get error in step 2: restoring backup to secondary database…<p> 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"> </p>
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.