Post reply

log shipping problem - can not use recent backup

  • August 24, 2004 at 8:06 pm

    #152274

    I have problem with setting up log shipping. First I backup the

    source database on the primary server.

    When I set up the log shipping, I use the "Initialize the Destination Databases" option and select the "Use most recent backup file" to initialize the destination database using the backup file.

    The following error appear and it fails. "Unable to copy initialization file to \\sourceserver\logshare\testlogshipbkup"

    I would like to know why I can't use most recent backup file to initialize the destination database.

    Yee


    yee

  • August 25, 2004 at 1:14 am

    #520456

    I'm guessing it's a rights problem.  In Query Analyzer, what is the result when you run this:

    master..xp_cmdshell 'dir \\sourceserver\logshare'

    If you get the 'Access denied' message, change the service startup account for the SQL Server service to a user that has rights to the remote shared folder, or grant rights on the remote folder to the current user.  Note that the LocalSystem account cannot access network shares.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • August 26, 2004 at 9:45 am

    #520745

    I'v tried to do that lots of times, receiving different errors (from timeouts to access violations >>> same source/destination servers.) >>> with no luck. Don't waste your time with that option >>> run through the wizzard and select the new backup option (it's been a while, I don't remember the exact wording).

     

    Good Luck

     

    Don't count what you do, do what counts.

    SQL Draggon

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply