DBCC DBREINDEX

Hi,
After runing this command on a table I noticed that logical scan
fragmentation increased.
I took a snapshot of the amount of fragementation before and after using
DBCC Showcontig and compared the results.
I would have expected the logical fragmentation to descrease.
Can someone please explain why this happened and would executing DBReindex
improve it.
Cheers
If an index has very low fragmentation then rebuilding it can increase the
logical scan fragmentation because the layout of pages changes. Please read
the whitepaper below for more details.
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"mm" <postto@.news.com> wrote in message
news:uihGHJlWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> After runing this command on a table I noticed that logical scan
> fragmentation increased.
> I took a snapshot of the amount of fragementation before and after using
> DBCC Showcontig and compared the results.
> I would have expected the logical fragmentation to descrease.
> Can someone please explain why this happened and would executing DBReindex
> improve it.
> Cheers
>
>

DBCC DBREINDEX

Hi,
After runing this command on a table I noticed that logical scan
fragmentation increased.
I took a snapshot of the amount of fragementation before and after using
DBCC Showcontig and compared the results.
I would have expected the logical fragmentation to descrease.
Can someone please explain why this happened and would executing DBReindex
improve it.
CheersIf an index has very low fragmentation then rebuilding it can increase the
logical scan fragmentation because the layout of pages changes. Please read
the whitepaper below for more details.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"mm" <postto@.news.com> wrote in message
news:uihGHJlWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> After runing this command on a table I noticed that logical scan
> fragmentation increased.
> I took a snapshot of the amount of fragementation before and after using
> DBCC Showcontig and compared the results.
> I would have expected the logical fragmentation to descrease.
> Can someone please explain why this happened and would executing DBReindex
> improve it.
> Cheers
>
>

DBCC DBREINDEX

Hi,
After runing this command on a table I noticed that logical scan
fragmentation increased.
I took a snapshot of the amount of fragementation before and after using
DBCC Showcontig and compared the results.
I would have expected the logical fragmentation to descrease.
Can someone please explain why this happened and would executing DBReindex
improve it.
CheersIf an index has very low fragmentation then rebuilding it can increase the
logical scan fragmentation because the layout of pages changes. Please read
the whitepaper below for more details.
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"mm" <postto@.news.com> wrote in message
news:uihGHJlWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi,
> After runing this command on a table I noticed that logical scan
> fragmentation increased.
> I took a snapshot of the amount of fragementation before and after using
> DBCC Showcontig and compared the results.
> I would have expected the logical fragmentation to descrease.
> Can someone please explain why this happened and would executing DBReindex
> improve it.
> Cheers
>
>

DBCC Consistency Errors after copying the backup file

Hello,
I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy) it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.
Has anybody come acrross this? How do you copy your backup files?
Any tip will be really appreciated.
Noel
Looks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed
<zerg2k@.yahoo.com> wrote in message
news:1163603641.098898.40150@.m7g2000cwm.googlegrou ps.com...
> Hello,
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy) it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
> Has anybody come acrross this? How do you copy your backup files?
> Any tip will be really appreciated.
> Noel
>

DBCC Consistency Errors after copying the backup file

Hello,
I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy) it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.
Has anybody come acrross this? How do you copy your backup files'
Any tip will be really appreciated.
NoelLooks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed
<zerg2k@.yahoo.com> wrote in message
news:1163603641.098898.40150@.m7g2000cwm.googlegroups.com...
> Hello,
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy) it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
> Has anybody come acrross this? How do you copy your backup files'
> Any tip will be really appreciated.
> Noel
>

DBCC Consistency Errors after copying the backup file

Hello,
I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy) it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.
Has anybody come acrross this? How do you copy your backup files'
Any tip will be really appreciated.
NoelLooks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed
<zerg2k@.yahoo.com> wrote in message
news:1163603641.098898.40150@.m7g2000cwm.googlegroups.com...
> Hello,
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy) it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
> Has anybody come acrross this? How do you copy your backup files'
> Any tip will be really appreciated.
> Noel
>