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 characters needed characters left characters exceeded

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

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

· Write an 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 characters needed characters left characters exceeded

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.