dbcc reindex ?

Is it required to do a dbcc reindex after a restore of a
database ? Has any one heard or read about this anyplace ?
TIA,
JackJack
There is nothing about the RESTORE itself that necessitates a REINDEX.
Restore will put all the data back on the same page numbers as in the
original database. If there was fragmentation before the backup, there will
be fragmentation after the restore. If you just did a REINDEX and removed
all fragmentation before backing up, there is no need to do it again after
restore.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jack A" <Jacka8@.excite.com> wrote in message
news:019b01c365a8$fd0d8a60$a301280a@.phx.gbl...
> Is it required to do a dbcc reindex after a restore of a
> database ? Has any one heard or read about this anyplace ?
> TIA,
> Jack|||Just want to add to Kalen's fine response. You should update the statistics
after a restore to ensure you are starting with an up to date set.
--
Andrew J. Kelly
SQL Server MVP
"Jack A" <Jacka8@.excite.com> wrote in message
news:019b01c365a8$fd0d8a60$a301280a@.phx.gbl...
> Is it required to do a dbcc reindex after a restore of a
> database ? Has any one heard or read about this anyplace ?
> TIA,
> Jacksql

DBCC Commands

Anyone knows of any good source of DBCC commands (not the usual ones
... the hindden commands), and TRACE flags?
TIA
PabloPablo,
Two copies of the same article, I believe.
http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.a
sp
From 6.5 days:
http://www.winnetmag.com/Article/ArticleID/14186/14186.html
http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx
Etc, etc, from Google.
Russell Fields
"PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
> Anyone knows of any good source of DBCC commands (not the usual ones
> ... the hindden commands), and TRACE flags?
> TIA
> Pablo|||Hi,
Just go to SQL Server books online and in Index type "DBCC", there you get
all the DBCC commands with explanation.
Thanks
Hari
MCDBA
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:evUydA15DHA.1636@.TK2MSFTNGP12.phx.gbl...
> Pablo,
> Two copies of the same article, I believe.
> http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
>
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.a
> sp
> From 6.5 days:
> http://www.winnetmag.com/Article/ArticleID/14186/14186.html
> http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx
> Etc, etc, from Google.
> Russell Fields
> "PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
> news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
> > Anyone knows of any good source of DBCC commands (not the usual ones
> > ... the hindden commands), and TRACE flags?
> >
> > TIA
> > Pablo
>|||Be very careful using undocumented (and hence unsupported) DBCC commands -
many of them can damage or destroy your database if used incorrectly. They
are there for use by PSS in the field - I don't recommend experimenting with
them.
What are you trying to do?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:evUydA15DHA.1636@.TK2MSFTNGP12.phx.gbl...
> Pablo,
> Two copies of the same article, I believe.
> http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
>
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.a
> sp
> From 6.5 days:
> http://www.winnetmag.com/Article/ArticleID/14186/14186.html
> http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx
> Etc, etc, from Google.
> Russell Fields
> "PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
> news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
> > Anyone knows of any good source of DBCC commands (not the usual ones
> > ... the hindden commands), and TRACE flags?
> >
> > TIA
> > Pablo
>|||Paul S Randal [MS] wrote:
> Be very careful using undocumented (and hence unsupported) DBCC
> commands - many of them can damage or destroy your database if used
> incorrectly. They are there for use by PSS in the field - I don't
> recommend experimenting with them.
> What are you trying to do?
I know all that but on real situations some of them had really helped
me a lot, so being able to know more about them can help me more in the
future.
No that I'm going to live using them but you know ... they are really
useful sometimes

dbcc checkdb

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.