The semaphore timeout period has expired

I got this error message on my SharePoint farm backup (using the STSADM command
STSADM.EXE -o backup -directory \srv001sqlbackups -backupmethod full):

Object SharePoint_Config failed in event OnBackup. For more information, see the error log located in the backup directory. SqlException: Write on “\srv003SP_Backupspbr0001000001D.bak” failed: 121(The semaphore timeout period has expired.) BACKUP DATABASE is terminating abnormally.

My first thought was that it conflicted with another backup job, so I moved the start time for the backup several times to see if that helped. Obviously it lost connection to the SQL server. But to move the start time did not help. I googled it but did not find anything helpful and after having analysed the Event Viewer errors and the backup log error, I saw that the error message was displayed almost immediately after the backup had started. And then I realised that maybe it had to do with the time limit for the backup job instead of a timeout against the SQL server. So, I increased the time limit in Scheduled tasks (which runs my bat file) with a couple of hours and then the backup went through without any errors.

Just one of those error messages that are hard to determine the right solution for….

Leave a Reply

4 Comments on "The semaphore timeout period has expired"

avatar
  Subscribe  
newest oldest most voted
Notify of
Lise
Guest

Thanks mekabar, for sharing!
/Lise

mekabar
Guest

This comment has been removed by the author.

mekabar
Guest
thank you Lise for this informationbut i have other way to recover sharepoint database using sqlRestore instructions for SQL-level backups Use the instructions in this section if you backed up the SharePoint SQL server databases by directly backing up the database files (.MDF, .LDF, and .NDF). 1. Stop all SQL Server, IIS, and SharePoint services. 2. Start the backup manager, go to the Control Panel page, and click the File Manager button. 3. Login to the file manager. Choose to restore all database files (either to their original locations or an alternate location; if you have existing files, we highly… Read more »
Anonymous
Guest

beautiful beautiful woman