Hi ,
When dbcc checkdb or checkcatalog executed on master db of Yukon got the
following error .
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be prepared for checking.
Re-run the command with the database in single-user or read-only mode. See
previous errors for more details.Which build are you using? On the Dec CTP release (9.00.0981)
dbcc checkdb('master')
dbcc checkcatalog('master')
work just fine for me.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23$IhL1sAFHA.1396@.tk2msftngp13.phx.gbl...
> Hi ,
> When dbcc checkdb or checkcatalog executed on master db of Yukon got the
> following error .
> Msg 5030, Level 16, State 12, Line 1
> The database could not be exclusively locked to perform the operation.
> Msg 7926, Level 16, State 1, Line 1
> Check statement aborted. The database could not be prepared for checking.
> Re-run the command with the database in single-user or read-only mode. See
> previous errors for more details.
>
>
>|||Thanks
am using 9.00.852
so is it like it won't work only if I give Dbcc checkdb
ARR
"Gert E.R. Drapers" <GertD@.SQLDev.Net> wrote in message
news:ucEiZ4sAFHA.1564@.TK2MSFTNGP09.phx.gbl...
> Which build are you using? On the Dec CTP release (9.00.0981)
> dbcc checkdb('master')
> dbcc checkcatalog('master')
> work just fine for me.
> GertD@.SQLDev.Net
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use.
> Copyright SQLDev.Net 1991-2005 All rights reserved.
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23$IhL1sAFHA.1396@.tk2msftngp13.phx.gbl...
checking.[vbcol=seagreen]
See[vbcol=seagreen]
>|||No it does work if you are in master and do not specify the database name as
well, running:
dbcc checkdb
dbcc checkcatalog
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Aju" <ajuonline@.yahoo.com> wrote in message
news:eBZ7WQtAFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Thanks
> am using 9.00.852
> so is it like it won't work only if I give Dbcc checkdb
>
> ARR
>
> "Gert E.R. Drapers" <GertD@.SQLDev.Net> wrote in message
> news:ucEiZ4sAFHA.1564@.TK2MSFTNGP09.phx.gbl...
> rights.
> checking.
> See
>|||Do you have these databases on a FAT file system? Checkdb in Yukon uses
database snapshots to allow online checks. If the database is on a
filesystem other than NTFS, or there is no space on the drive for a
snapshot, then online checks cannot be done and another mechanism for
achieving transactional consistency is required instead. You should have
seen some other errors which will have explained. This behavior is fully
documented in Beta 3 BOL.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aju" <ajuonline@.yahoo.com> wrote in message
news:eBZ7WQtAFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Thanks
> am using 9.00.852
> so is it like it won't work only if I give Dbcc checkdb
>
> ARR
>
> "Gert E.R. Drapers" <GertD@.SQLDev.Net> wrote in message
> news:ucEiZ4sAFHA.1564@.TK2MSFTNGP09.phx.gbl...
> rights.
the[vbcol=seagreen]
> checking.
> See
>
No comments:
Post a Comment