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

Share this blog post:
0 0 vote
Rate this article!
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

4 Comments
newest
oldest most voted
Inline Feedbacks
View all comments
Anonymous

beautiful beautiful woman

mekabar

This comment has been removed by the author.

mekabar

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 »

Lise

Thanks mekabar, for sharing!
/Lise