Hi
Should I be using DBCC CHECKDB on tempdb for SQL 7 and 2K?
TIA
JasonHi Jason,
You can, but I would not worry about it as the tempdb is
designed to hold temporary stuff which is then removed
from the db.
So there is nothing stopping you, but there is no need.
Peter
>--Original Message--
>Hi
>Should I be using DBCC CHECKDB on tempdb for SQL 7 and 2K?
>TIA
>Jason
>
>.
>|||Thanks Peter
I do usually perform this maintenance check on the database. I've started to
receive 8906 errors and the solution is to put the database into single user
mode and use the repair parameter, however, tempdb cannot be put into single
user mode. I've not come across this before.
Cheers
Jason
"Peter" <nospam@.thisemailaddress.co.uk> wrote in message
news:0ee401c3618a$3292f9e0$a101280a@.phx.gbl...
> Hi Jason,
> You can, but I would not worry about it as the tempdb is
> designed to hold temporary stuff which is then removed
> from the db.
> So there is nothing stopping you, but there is no need.
> Peter
>
> >--Original Message--
> >Hi
> >
> >Should I be using DBCC CHECKDB on tempdb for SQL 7 and 2K?
> >
> >TIA
> >
> >Jason
> >
> >
> >.
> >|||I see what you mean.
All I can think of one possible solution which would be to
shrink the data / log file and see if that clears out the
problem.
Peter
>--Original Message--
>Thanks Peter
>I do usually perform this maintenance check on the
database. I've started to
>receive 8906 errors and the solution is to put the
database into single user
>mode and use the repair parameter, however, tempdb cannot
be put into single
>user mode. I've not come across this before.
>Cheers
>Jason
>
>"Peter" <nospam@.thisemailaddress.co.uk> wrote in message
>news:0ee401c3618a$3292f9e0$a101280a@.phx.gbl...
>> Hi Jason,
>> You can, but I would not worry about it as the tempdb is
>> designed to hold temporary stuff which is then removed
>> from the db.
>> So there is nothing stopping you, but there is no need.
>> Peter
>>
>> >--Original Message--
>> >Hi
>> >
>> >Should I be using DBCC CHECKDB on tempdb for SQL 7 and
2K?
>> >
>> >TIA
>> >
>> >Jason
>> >
>> >
>> >.
>> >
>
>.
>|||Thanks for your reply Peter
I'll try that later. I have had this problem before and it went away after 2
days, so I'm a bit confused
Cheers
Jason
"Peter" <nospam@.thisemailaddress.co.uk> wrote in message
news:107201c3619a$91b0d950$a101280a@.phx.gbl...
> I see what you mean.
> All I can think of one possible solution which would be to
> shrink the data / log file and see if that clears out the
> problem.
> Peter
>
> >--Original Message--
> >Thanks Peter
> >
> >I do usually perform this maintenance check on the
> database. I've started to
> >receive 8906 errors and the solution is to put the
> database into single user
> >mode and use the repair parameter, however, tempdb cannot
> be put into single
> >user mode. I've not come across this before.
> >
> >Cheers
> >
> >Jason
> >
> >
> >
> >"Peter" <nospam@.thisemailaddress.co.uk> wrote in message
> >news:0ee401c3618a$3292f9e0$a101280a@.phx.gbl...
> >> Hi Jason,
> >>
> >> You can, but I would not worry about it as the tempdb is
> >> designed to hold temporary stuff which is then removed
> >> from the db.
> >>
> >> So there is nothing stopping you, but there is no need.
> >>
> >> Peter
> >>
> >>
> >> >--Original Message--
> >> >Hi
> >> >
> >> >Should I be using DBCC CHECKDB on tempdb for SQL 7 and
> 2K?
> >> >
> >> >TIA
> >> >
> >> >Jason
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Hi Jason,
What version of SQL Server are you using? If you are on SQL Server 7.0,
make sure you have latest service pack.
I did a quick search on any known issue. I found one. (Not saying that you
are hitting this however)
FIX: Attentions During Nonlogged Allocations in Tempdb Can Result in ID:
278363.KB.EN-US
http://support.microsoft.com/?id=278363
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
