-
Title
Error: Msg 50000, Level 19, State 1, Line 1 during backup process -
Description
Error: Msg 50000, Level 19, State 1, Line 1
In the LiteSpeed Log:
12/4/2006 10:24:03 AM: OleDbConn::execTsql ->
12/4/2006 10:24:03 AM: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT media_set_id
FROM msdb..backupmediafamily AS bmf
WHERE substring(bmf.physical_device_name, 5, 36) = '2DD41790-D0EF-4C5A-AEA1-79293F8D41CF'
12/4/2006 10:24:06 AM: itemcnt=2
12/4/2006 10:24:06 AM: hr=40ec9
12/4/2006 10:24:06 AM:
12/4/2006 10:24:06 AM: num rows=2, col=1
12/4/2006 10:24:06 AM: val(0,0)=1051625
12/4/2006 10:24:06 AM: OleDbConn::execTsql ->
12/4/2006 10:24:06 AM: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT backup_set_id
FROM msdb..backupset WITH (NOLOCK)
WHERE media_set_id = 1051625
12/4/2006 10:24:06 AM: hr=80004005
12/4/2006 10:24:06 AM: Could not continue scan with NOLOCK due to data movement. -
Cause
Cannot update the info in MSDB.
-
Resolution
Run DBCC checkdb('msdb', repair_allow_data_loss) command in order to try and fix the msdb database. -
Additional Information
All versions of LiteSpeed
All versions of SQL Server