Tuesday, March 27, 2012

Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regards
Is the model db backing up right now? Have you backed it up recently?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards
|||The error message says it all. There are some operations that cannot be performed simultaneously for a
database. Make sure you schedule your jobs properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards
sql

No comments:

Post a Comment