SQL Server Performance Forum – Threads Archive
Error during Transaction Log Backup
Hi All I am making transaction log backup of two databases with following settings: 1. DB1: Full Backup every 12 hours, delete files older than 1 day2. DB2: Full Backup every 12 hours, delete files older than 1 day
3. Transaction Log DB1: Backup every 1 hour, delete files older than 1 day
4. Transaction Log DB2: Backup every 1 hour, delete files older than 1 day. Now what is happening after 24 hours somehow the backup is created for transaction logs of DB1 but at the end I am getting the following error: 18210 :BackupDiskFile::RequestDurableMedia: failure on backup device ‘\backupTR_PDBDB1_tlog_200509132300.TRN’. Operating system error 64(error not found). While at the same time the backup of DB2 is successful. Can someone tell me what might be the reason for this problem Regards Mansoor
Seems to be error with your network.
You should first backup to the local disk then copy the file to the network resource. Backups are so important and you can’t afford to not get a backup due to a network hiccup.
—————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Ensure SQLAgent account has required permissions on specified path to perform the action. 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.
Hi Mani1,<br /><br />Check the above points mentionned by Satya and dineshasanka first , if the error persists,then i think the problem MAY be a session timeout, you can go go :<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServiceslanmanworkstationparam<br />etersSessTimeout<br /><br />Increase this value to 600 (10 minutes) and see how it goes.<br /><br />Hope this helps[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br /><br /><br /><br />AKTHAR DILMOHAMUD<br />65 BENARES ST<br />PORT LOUIS<br />MAURITIUS
]]>