Showing posts with label source. Show all posts
Showing posts with label source. Show all posts

Friday, February 24, 2012

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
>
Posted by sco at 4:43 AM 0 comments
Labels: , , , , , , , , , , , , , , , , , ,

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
>
Posted by sco at 4:43 AM 0 comments
Labels: , , , , , , , , , , , , , , , , , ,

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
>
Posted by sco at 4:43 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

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/U...00UndocDBCC.htm
http://www.sql-server-performance.c...cumented_dbcc.a
sp
From 6.5 days:
http://www.winnetmag.com/Article/Ar...4186/14186.html
http://www.extremeexperts.com/sql/a...TraceFlags.aspx
Etc, etc, from Google.
Russell Fields
"PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
quote:

> 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...
quote:

> Pablo,
> Two copies of the same article, I believe.
> http://www.mssqlcity.com/Articles/U...00UndocDBCC.htm
>

http://www.sql-server-performance.c...cumented_dbcc.a
quote:

> sp
> From 6.5 days:
> http://www.winnetmag.com/Article/Ar...4186/14186.html
> http://www.extremeexperts.com/sql/a...TraceFlags.aspx
> Etc, etc, from Google.
> Russell Fields
> "PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
> news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
>
|||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...
quote:

> Pablo,
> Two copies of the same article, I believe.
> http://www.mssqlcity.com/Articles/U...00UndocDBCC.htm
>

http://www.sql-server-performance.c...cumented_dbcc.a
quote:

> sp
> From 6.5 days:
> http://www.winnetmag.com/Article/Ar...4186/14186.html
> http://www.extremeexperts.com/sql/a...TraceFlags.aspx
> Etc, etc, from Google.
> Russell Fields
> "PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
> news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
>
|||Paul S Randal [MS] wrote:
quote:

> 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
Posted by sco at 4:42 AM 0 comments
Labels: , , , , , , , , , , ,

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
Posted by sco at 4:42 AM 0 comments
Labels: , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)