question

Naveen Kumar avatar image
Naveen Kumar asked

Error While taking Backup

Hi, while trying to take backup I am getting the following error, pls suggest me how to overcome this, System.Data.SqlClient.SqlError: Lock request time out period exceeded. (Microsoft.SqlServer.Smo) For help, click: Thanks in Advance
sql-server-2008backup
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton avatar image Shawn_Melton commented ·
Have you looked at the your ERRORLOG for your instance to see if any additional information is provided? Are you trying to backup a user database or system database?
0 Likes 0 ·

1 Answer

·
sp_lock avatar image
sp_lock answered
If this is through the GUI then try and script the [backup][1]. Then right click in the query window and set the "Execution time-out" to 0. Aslo, change the **STATS** to 1 so you can see the progress BACKUP DATABASE [DB2] TO DISK = N'e:\SQLBackups\db2.bak' WITH NOFORMAT, NOINIT, NAME = N'DB2-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 1 Just read the error PROPERLY!!! When taking your backup you may want to execute sp_who2 to see what is blocking the system during a backup, or you can use Adam Mechanics [script][2] which a richer proc for activity debugging. [1]: http://msdn.microsoft.com/en-us/library/ms186865.aspx [2]: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.