Post reply

Log Shipping for the 1st time

  • November 25, 2005 at 3:31 am

    #110388

    I am setting up log shipping for the first time and have several questions. What happens to log shipping after I take a daily full backup? I assume I would have to restore this full backup to the secondary server which would be a right pain in the... How can I use/set up log shipping if I take a full backup every evening at 21:00?

    I have set up the secondary server as the monitor and when I checked this morning it is marked with a red cross. When I click on 'View Backup History' it returns 'The server '(LOCAL)' must be registered in order to perform this operation. Register server?' Unfortunately, it wont let me do this as (LOCAL) is actually the primary server and hence not local!! Should I remove log shipping and set it up again with the monitor on the primary?

    What is the .tuf file?

    Thanks in anticipation

     

     

  • November 25, 2005 at 5:05 pm

    #605917

    Is this using sql enterprise edition or higher?

  • November 27, 2005 at 3:07 am

    #605978

    yes i'm using enterpeise edition sp3a on Windows 2003 but moving to sp4 shortly

  • March 12, 2006 at 3:29 pm

    #626152

    I had this issue too.

    Turned out to be that I setup enterprise log shipping whilst logged on locally to my primary server with the primary server registered as (Local) - pretty normal practice I would think!

    It turns out that good ole logshipping wizard grabs this registration and chicks it into the logshipping monitor tables on the monitoring server (in the msdb database)

    This means that when you are on the monitoring server, it'll try to find the logs on 'local' (this time being the monitoring server if you are connected locally on this server) and wont find the primary server logs.

    I went into the logshipping tables on the monitoring server and manually changed the primary server record to reflect the correct server name, and hey presto! can see logs, and the monitoring server also got rid of that horrible red cross.

    (this also shows itself on monitoring if you have copies and uploads showing in-sync, but the monitoring server not showing the backups as being up to date.)

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

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