asked
SQL Server Backup running for a long time with out any result
Hello, we are using SQl Server 10.0.2531 version. i executed the database backup query for one database whose size is 1GB and it is running for the last 5 hrs with out any result. where as in the same instance another database size 5gb which completed in 1 minute. i am confused why the backup was not happening to that database.please suggest any resolution for this. when i ran select * from sys.dm_exec_requests left join sys.dm_os_waiting tasks then under resource description i found the following: databaselock subresource=BULKOP_BACKUP_DB dbid=8 id=lock22d791700 mode=U
Sounds like a concurrency issue with backups vs backups or with another operations. You can not run two concurrent jobs that backup your data, or log. It would generate the BULKOP_BACKUP_DB wait with a U lock. Also you can't add files, shrink files or mess with recovery model changes during backups. Have a look at: [Microsoft][1] , you might get closer to your problem. [1]:
http://support2.microsoft.com/kb/2979636
Run Trace and check what is going the server.
16 People are following this question.
