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>&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>
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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |