Problem with Simple Log Shipping

Posted on 2006-05-25
Last Modified: 2008-01-09

I have the following problem. I am trying to log ship between two standard SQL 2000 servers. I have installed SP_ShipLog on the primary server, in the master database, and sp_applystandbylog on the secondary server in the master database.

When I run the sp_shiplog from the primary server, the log.bak gets copied correctly to a share on the secondary server. However, when the job on the primary server trys to apply the log to the secondary server's database (which is read-only and set up accept the application of transaction logs), I get the following message:

Executed as user: domain1\troutSQL. ...roup\mssql\TransLogs\TEST_20060525_1037_LOG.BAK [SQLSTATE 01000] (Message 0)  BACKUP LOG successfully processed 0 pages in 0.372 seconds (0.000 MB/sec). [SQLSTATE 01000] (Message 3014)  

Execute [SQLServer01].master.dbo.sp_ApplyStandByLog N'Yoda',N'\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\Yoda_20060525_1037_LOG.BAK',N'\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\undo_yoda.dat' [SQLSTATE 01000] (Message 0)  

Executing RESTORE LOG Yoda FROM DISK='\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\Yoda_' WITH STANDBY='\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\undo_yoda.dat [SQLSTATE 01000]
(Message 0)  RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013)  

Cannot open backup device '\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\Yoda_'.
Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201)  Error severity levels greater than 18 can...  The step failed.

    1 Comment
    LVL 10

    Accepted Solution

    Try restoring the database on teh secondary server again using the WITH NORECOVERY option ...   this will leave teh seconday db in loading state ..

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now