SQL Server Performance Forum – Threads Archive

log shipping/out of sync..again

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

any thoughts?? anyone?

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.

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

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

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

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

Anil : Read from below link.. there Dinesh has already posted answer for the same question you are asking: - http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8361</a> Restoring a Database from a Backup File on a Remote Server to the Local Server 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. Restoring a Database from a Local File to a Remote Server 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. 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=’

‘ /> Deepak Kumar –An eye for an eye and everyone shall be blind

must be a kapoor thing lol kidding

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

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

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.

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

]]>