SQL Server Performance

log shipping/out of sync..again

Discussion in 'SQL Server Log Shipping' started by sunnylicious, May 6, 2005.

  1. sunnylicious New Member

    Hello, Ive read some of the previous posts and searched through many of them...yet I still have a problem with log shipping going out of sync. I have 2 servers running SQL enterprise, with the primary server functioning as the monitoring server as well.
    I have 23 db's on the machine and only 4 of them reporting out of sync(error 14420/14421) in log shipping monitor. I have the shipping time set as copy and load frequencey of 15minutes, out of sync threshold at 45 minutes which are the defaults. Transaction log backup set at Occurs every 1 day(s), every 15 minute(s) between 12:00:00 AM and 11:59:59 PM, but not to do a complete backup of the DB as part of maintenance plan.

    I have ensured there are no connectivity problems between the 2 servers, and username access is configured properly. I looked at the MS INF on this error and was unable to find something that can resolve this issue. Is there a way for me to physically sync them? Any help is certainly appreciated, TIA
  2. sunnylicious New Member

    any thoughts?? anyone?
  3. satya Moderator

    KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;329133 refers - By definition, message 14420 does not necessarily indicate a problem with log shipping. The message indicates that the difference between the last backed up file and current time on the monitor server is greater than the time that is set for the Backup Alert threshold.

    I advise you to differentiate the big databases in a seperate plan and small ones in a seperate plans in order to avoid any contention of these errors.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. sunnylicious New Member

    not quite sure what you mean, but the db's are in seperate plans....
    I now have 3 that arent working, 1 was removed....
    db a is 9meg
    db b is 35meg
    db c is 120 meg
    the db's that are working with log shipping correctly are above and around this range....
    thanks for the reply btw
  5. anilkpr New Member

    have seen your answer for a question "How to take back to another
    machine
    on a network. "

    You have answered to create a back up device on network machine and
    take the
    backup. I have created a device in another machine, when ever I am
    trying to
    take the backup, system is giving an error like "cannot open backup
    device
    'networkdevice'. Device error or device off-line. Backup database
    terminatin
    abnoamally".

    Pls advise me how can I solve it..??
  6. sunnylicious New Member

    Im sorry anil..I dont know what you just said...
  7. anilkpr New Member

    quote:Originally posted by sunnylicious

    Im sorry anil..I dont know what you just said...

    Hi,

    I want to take the Backup of an SQL DB to a network machine. Could you pls tell how can I do it..??

    Anil
  8. deepakontheweb New Member

    Anil : Read from below link.. there Dinesh has already posted answer for the same question you are asking: -<br /><br /<a target="_blank" href=http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8361>http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8361</a><br /><br />Restoring a Database from a Backup File on a Remote Server to the Local Server<br />To restore a database from a file that is located on a different computer (for example, restoring from a mapped network drive), the Windows account used to start the SQL Server service has to be a non-system account with full control privileges to the backup file.<br /><br /><br /><br />Restoring a Database from a Local File to a Remote Server<br />If you are restoring from a local file to a remote server, use a UNC path that points to your local drive from the remote server. The Windows account used to start the remote SQL Server service has to be a non-system account with full control privileges to the backup file.<br /><br /><br />Please try to create a new post for your question after reading old related post, instead of appending it to anywhere else. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />Deepak Kumar<br /><br />--An eye for an eye and everyone shall be blind
  9. sunnylicious New Member

    must be a kapoor thing lol kidding
  10. anilkpr New Member


    But Deepak, Dinesh is talking only about Restore, I am asking about Backup. How can I take backup to a network machine..??

    Anil
  11. deepakontheweb New Member


    The same concepts apply on backup too.. try it and let us know if you don't succeed.

    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  12. satya Moderator

    You can perform the backup to a network machine using the UNC path in the BACKUP statement.
    The recommended method is to perform a local backup and then copy the file the network location, in order to reduce the load on SQL Server during backup process.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  13. Gary Williams New Member

    You most likey need to create a NULL Session share within the registry on the remote machine once you have created the network share. If SQL Agent service is using the localadmin account it can not autenticate over the network. Hence the NULL Session share

Share This Page