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.[vbcol=seagreen]
> 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
>
|||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...[vbcol=seagreen]
> 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
> checking.
> See
>
Showing posts with label checkcatalog. Show all posts
Showing posts with label checkcatalog. Show all posts
Friday, February 17, 2012
dbcc checkdb in Yukon
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
>
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
>
dbcc checkdb in Yukon
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...
> > 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.
> >
> >
> >
> >
> >
> >
>|||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...
>> 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.
>> >
>> >
>> >
>> >
>> >
>> >
>>
>|||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...
> > 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.
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
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...
> > 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.
> >
> >
> >
> >
> >
> >
>|||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...
>> 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.
>> >
>> >
>> >
>> >
>> >
>> >
>>
>|||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...
> > 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.
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
Tuesday, February 14, 2012
dbcc checkcatalog problem
Hi,
we are msdn partner and have sql server 2000 enterprise.
We installed it three times and on every server we get errors, when using
dbcc checkcatalog in the msdb.
Can it be an error on the cd, has anny one else this problem?
Regards
Alexander PfingstlWorks fine for me. Do you have the latest service pack installed?
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> we are msdn partner and have sql server 2000 enterprise.
> We installed it three times and on every server we get errors, when using
> dbcc checkcatalog in the msdb.
> Can it be an error on the cd, has anny one else this problem?
> Regards
> Alexander Pfingstl
>|||Yes I have.
We now found out, that on a new CD the database is correct.
Is it possible to exchange the database.
I would stop the server:
then delete the old msdb-Database Files and copy the new ones into the
directory.
Then start the Server again.
Will this work?
Or cant I do this with msdb?
Thanks!
Alexander
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Works fine for me. Do you have the latest service pack installed?
> --
> Andrew J. Kelly SQL MVP
>
> "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
using[vbcol=seagreen]
>|||I guess this is theoretically possible but I don't know if it would be
supported officially or not. You would at the least loose any info you may
have in the MSDB database if any.
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:u3rWcaSeEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Yes I have.
> We now found out, that on a new CD the database is correct.
> Is it possible to exchange the database.
> I would stop the server:
> then delete the old msdb-Database Files and copy the new ones into the
> directory.
> Then start the Server again.
> Will this work?
> Or cant I do this with msdb?
> Thanks!
> Alexander
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> using
>
we are msdn partner and have sql server 2000 enterprise.
We installed it three times and on every server we get errors, when using
dbcc checkcatalog in the msdb.
Can it be an error on the cd, has anny one else this problem?
Regards
Alexander PfingstlWorks fine for me. Do you have the latest service pack installed?
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> we are msdn partner and have sql server 2000 enterprise.
> We installed it three times and on every server we get errors, when using
> dbcc checkcatalog in the msdb.
> Can it be an error on the cd, has anny one else this problem?
> Regards
> Alexander Pfingstl
>|||Yes I have.
We now found out, that on a new CD the database is correct.
Is it possible to exchange the database.
I would stop the server:
then delete the old msdb-Database Files and copy the new ones into the
directory.
Then start the Server again.
Will this work?
Or cant I do this with msdb?
Thanks!
Alexander
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Works fine for me. Do you have the latest service pack installed?
> --
> Andrew J. Kelly SQL MVP
>
> "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
using[vbcol=seagreen]
>|||I guess this is theoretically possible but I don't know if it would be
supported officially or not. You would at the least loose any info you may
have in the MSDB database if any.
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:u3rWcaSeEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Yes I have.
> We now found out, that on a new CD the database is correct.
> Is it possible to exchange the database.
> I would stop the server:
> then delete the old msdb-Database Files and copy the new ones into the
> directory.
> Then start the Server again.
> Will this work?
> Or cant I do this with msdb?
> Thanks!
> Alexander
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> using
>
dbcc checkcatalog problem
Hi,
we are msdn partner and have sql server 2000 enterprise.
We installed it three times and on every server we get errors, when using
dbcc checkcatalog in the msdb.
Can it be an error on the cd, has anny one else this problem?
Regards
Alexander PfingstlWorks fine for me. Do you have the latest service pack installed?
--
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> we are msdn partner and have sql server 2000 enterprise.
> We installed it three times and on every server we get errors, when using
> dbcc checkcatalog in the msdb.
> Can it be an error on the cd, has anny one else this problem?
> Regards
> Alexander Pfingstl
>|||Yes I have.
We now found out, that on a new CD the database is correct.
Is it possible to exchange the database.
I would stop the server:
then delete the old msdb-Database Files and copy the new ones into the
directory.
Then start the Server again.
Will this work?
Or can´t I do this with msdb?
Thanks!
Alexander
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Works fine for me. Do you have the latest service pack installed?
> --
> Andrew J. Kelly SQL MVP
>
> "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > we are msdn partner and have sql server 2000 enterprise.
> > We installed it three times and on every server we get errors, when
using
> > dbcc checkcatalog in the msdb.
> >
> > Can it be an error on the cd, has anny one else this problem?
> >
> > Regards
> > Alexander Pfingstl
> >
> >
>|||I guess this is theoretically possible but I don't know if it would be
supported officially or not. You would at the least loose any info you may
have in the MSDB database if any.
--
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:u3rWcaSeEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Yes I have.
> We now found out, that on a new CD the database is correct.
> Is it possible to exchange the database.
> I would stop the server:
> then delete the old msdb-Database Files and copy the new ones into the
> directory.
> Then start the Server again.
> Will this work?
> Or can´t I do this with msdb?
> Thanks!
> Alexander
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Works fine for me. Do you have the latest service pack installed?
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> > news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > we are msdn partner and have sql server 2000 enterprise.
> > > We installed it three times and on every server we get errors, when
> using
> > > dbcc checkcatalog in the msdb.
> > >
> > > Can it be an error on the cd, has anny one else this problem?
> > >
> > > Regards
> > > Alexander Pfingstl
> > >
> > >
> >
> >
>
we are msdn partner and have sql server 2000 enterprise.
We installed it three times and on every server we get errors, when using
dbcc checkcatalog in the msdb.
Can it be an error on the cd, has anny one else this problem?
Regards
Alexander PfingstlWorks fine for me. Do you have the latest service pack installed?
--
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> we are msdn partner and have sql server 2000 enterprise.
> We installed it three times and on every server we get errors, when using
> dbcc checkcatalog in the msdb.
> Can it be an error on the cd, has anny one else this problem?
> Regards
> Alexander Pfingstl
>|||Yes I have.
We now found out, that on a new CD the database is correct.
Is it possible to exchange the database.
I would stop the server:
then delete the old msdb-Database Files and copy the new ones into the
directory.
Then start the Server again.
Will this work?
Or can´t I do this with msdb?
Thanks!
Alexander
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Works fine for me. Do you have the latest service pack installed?
> --
> Andrew J. Kelly SQL MVP
>
> "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > we are msdn partner and have sql server 2000 enterprise.
> > We installed it three times and on every server we get errors, when
using
> > dbcc checkcatalog in the msdb.
> >
> > Can it be an error on the cd, has anny one else this problem?
> >
> > Regards
> > Alexander Pfingstl
> >
> >
>|||I guess this is theoretically possible but I don't know if it would be
supported officially or not. You would at the least loose any info you may
have in the MSDB database if any.
--
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:u3rWcaSeEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Yes I have.
> We now found out, that on a new CD the database is correct.
> Is it possible to exchange the database.
> I would stop the server:
> then delete the old msdb-Database Files and copy the new ones into the
> directory.
> Then start the Server again.
> Will this work?
> Or can´t I do this with msdb?
> Thanks!
> Alexander
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Works fine for me. Do you have the latest service pack installed?
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> > news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > we are msdn partner and have sql server 2000 enterprise.
> > > We installed it three times and on every server we get errors, when
> using
> > > dbcc checkcatalog in the msdb.
> > >
> > > Can it be an error on the cd, has anny one else this problem?
> > >
> > > Regards
> > > Alexander Pfingstl
> > >
> > >
> >
> >
>
Subscribe to:
Posts (Atom)