Hello,
I′m testing the execution of my database backups with omniback. These
backups fails so i've made a trace and i get the following error: "Error:
7983, Severity: 14, State: 14"
"dbcc showfilestats( 1 )"
The user used to access the databases is a domain admin but in sql server i
only give him the backup operator database role.
If this user were sysadmin everything goes fine but i want to limit his
access.
Do you have any idea about this?
What does the documentation for the backup vendor say? Does it say that the login need to be
sysadmin. If not, you have a bug in their program. If it does, well...
You cannot grant permissions on this. Also, this is an undocumented command, so the backup vendor is
using it at their own risk.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> Hello,
> Im testing the execution of my database backups with omniback. These
> backups fails so i've made a trace and i get the following error: "Error:
> 7983, Severity: 14, State: 14"
> "dbcc showfilestats( 1 )"
> The user used to access the databases is a domain admin but in sql server i
> only give him the backup operator database role.
> If this user were sysadmin everything goes fine but i want to limit his
> access.
> Do you have any idea about this?
>
|||Moreover, the SQL Backup alternatives typically want to use the Virtual
Backup Device Interface API. At this time, only system admins can make calls
with this interface. Backup Operators do not.
Sincerely,
Anthony Thomas
"Tibor Karaszi" wrote:
> What does the documentation for the backup vendor say? Does it say that the login need to be
> sysadmin. If not, you have a bug in their program. If it does, well...
> You cannot grant permissions on this. Also, this is an undocumented command, so the backup vendor is
> using it at their own risk.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
>
>
|||That undocumented DBCC command is SA-only - there's no way around this.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:354E62F2-2E58-4D0A-BE1F-E1AA3D8262BE@.microsoft.com...
> Moreover, the SQL Backup alternatives typically want to use the Virtual
> Backup Device Interface API. At this time, only system admins can make
calls[vbcol=seagreen]
> with this interface. Backup Operators do not.
> Sincerely,
>
> Anthony Thomas
>
> "Tibor Karaszi" wrote:
the login need to be[vbcol=seagreen]
command, so the backup vendor is[vbcol=seagreen]
"Error:[vbcol=seagreen]
server i[vbcol=seagreen]
his[vbcol=seagreen]
Showing posts with label trace. Show all posts
Showing posts with label trace. Show all posts
Sunday, March 25, 2012
DBCC SHOWFILESTATS
Hello,
I′m testing the execution of my database backups with omniback. These
backups fails so i've made a trace and i get the following error: "Error:
7983, Severity: 14, State: 14"
"dbcc showfilestats( 1 )"
The user used to access the databases is a domain admin but in sql server i
only give him the backup operator database role.
If this user were sysadmin everything goes fine but i want to limit his
access.
Do you have any idea about this?What does the documentation for the backup vendor say? Does it say that the
login need to be
sysadmin. If not, you have a bug in their program. If it does, well...
You cannot grant permissions on this. Also, this is an undocumented command,
so the backup vendor is
using it at their own risk.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> Hello,
> Im testing the execution of my database backups with omniback. These
> backups fails so i've made a trace and i get the following error: "Error:
> 7983, Severity: 14, State: 14"
> "dbcc showfilestats( 1 )"
> The user used to access the databases is a domain admin but in sql server
i
> only give him the backup operator database role.
> If this user were sysadmin everything goes fine but i want to limit his
> access.
> Do you have any idea about this?
>|||Moreover, the SQL Backup alternatives typically want to use the Virtual
Backup Device Interface API. At this time, only system admins can make call
s
with this interface. Backup Operators do not.
Sincerely,
Anthony Thomas
"Tibor Karaszi" wrote:
> What does the documentation for the backup vendor say? Does it say that th
e login need to be
> sysadmin. If not, you have a bug in their program. If it does, well...
> You cannot grant permissions on this. Also, this is an undocumented comman
d, so the backup vendor is
> using it at their own risk.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
>
>|||That undocumented DBCC command is SA-only - there's no way around this.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:354E62F2-2E58-4D0A-BE1F-E1AA3D8262BE@.microsoft.com...
> Moreover, the SQL Backup alternatives typically want to use the Virtual
> Backup Device Interface API. At this time, only system admins can make
calls[vbcol=seagreen]
> with this interface. Backup Operators do not.
> Sincerely,
>
> Anthony Thomas
>
> "Tibor Karaszi" wrote:
>
the login need to be[vbcol=seagreen]
command, so the backup vendor is[vbcol=seagreen]
"Error:[vbcol=seagreen]
server i[vbcol=seagreen]
his[vbcol=seagreen]
I′m testing the execution of my database backups with omniback. These
backups fails so i've made a trace and i get the following error: "Error:
7983, Severity: 14, State: 14"
"dbcc showfilestats( 1 )"
The user used to access the databases is a domain admin but in sql server i
only give him the backup operator database role.
If this user were sysadmin everything goes fine but i want to limit his
access.
Do you have any idea about this?What does the documentation for the backup vendor say? Does it say that the
login need to be
sysadmin. If not, you have a bug in their program. If it does, well...
You cannot grant permissions on this. Also, this is an undocumented command,
so the backup vendor is
using it at their own risk.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> Hello,
> Im testing the execution of my database backups with omniback. These
> backups fails so i've made a trace and i get the following error: "Error:
> 7983, Severity: 14, State: 14"
> "dbcc showfilestats( 1 )"
> The user used to access the databases is a domain admin but in sql server
i
> only give him the backup operator database role.
> If this user were sysadmin everything goes fine but i want to limit his
> access.
> Do you have any idea about this?
>|||Moreover, the SQL Backup alternatives typically want to use the Virtual
Backup Device Interface API. At this time, only system admins can make call
s
with this interface. Backup Operators do not.
Sincerely,
Anthony Thomas
"Tibor Karaszi" wrote:
> What does the documentation for the backup vendor say? Does it say that th
e login need to be
> sysadmin. If not, you have a bug in their program. If it does, well...
> You cannot grant permissions on this. Also, this is an undocumented comman
d, so the backup vendor is
> using it at their own risk.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
>
>|||That undocumented DBCC command is SA-only - there's no way around this.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:354E62F2-2E58-4D0A-BE1F-E1AA3D8262BE@.microsoft.com...
> Moreover, the SQL Backup alternatives typically want to use the Virtual
> Backup Device Interface API. At this time, only system admins can make
calls[vbcol=seagreen]
> with this interface. Backup Operators do not.
> Sincerely,
>
> Anthony Thomas
>
> "Tibor Karaszi" wrote:
>
the login need to be[vbcol=seagreen]
command, so the backup vendor is[vbcol=seagreen]
"Error:[vbcol=seagreen]
server i[vbcol=seagreen]
his[vbcol=seagreen]
DBCC SHOWFILESTATS
Hello,
I´m testing the execution of my database backups with omniback. These
backups fails so i've made a trace and i get the following error: "Error:
7983, Severity: 14, State: 14"
"dbcc showfilestats( 1 )"
The user used to access the databases is a domain admin but in sql server i
only give him the backup operator database role.
If this user were sysadmin everything goes fine but i want to limit his
access.
Do you have any idea about this?What does the documentation for the backup vendor say? Does it say that the login need to be
sysadmin. If not, you have a bug in their program. If it does, well...
You cannot grant permissions on this. Also, this is an undocumented command, so the backup vendor is
using it at their own risk.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> Hello,
> I´m testing the execution of my database backups with omniback. These
> backups fails so i've made a trace and i get the following error: "Error:
> 7983, Severity: 14, State: 14"
> "dbcc showfilestats( 1 )"
> The user used to access the databases is a domain admin but in sql server i
> only give him the backup operator database role.
> If this user were sysadmin everything goes fine but i want to limit his
> access.
> Do you have any idea about this?
>|||Moreover, the SQL Backup alternatives typically want to use the Virtual
Backup Device Interface API. At this time, only system admins can make calls
with this interface. Backup Operators do not.
Sincerely,
Anthony Thomas
"Tibor Karaszi" wrote:
> What does the documentation for the backup vendor say? Does it say that the login need to be
> sysadmin. If not, you have a bug in their program. If it does, well...
> You cannot grant permissions on this. Also, this is an undocumented command, so the backup vendor is
> using it at their own risk.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> > Hello,
> >
> > I´m testing the execution of my database backups with omniback. These
> > backups fails so i've made a trace and i get the following error: "Error:
> > 7983, Severity: 14, State: 14"
> > "dbcc showfilestats( 1 )"
> >
> > The user used to access the databases is a domain admin but in sql server i
> > only give him the backup operator database role.
> > If this user were sysadmin everything goes fine but i want to limit his
> > access.
> >
> > Do you have any idea about this?
> >
>
>|||That undocumented DBCC command is SA-only - there's no way around this.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:354E62F2-2E58-4D0A-BE1F-E1AA3D8262BE@.microsoft.com...
> Moreover, the SQL Backup alternatives typically want to use the Virtual
> Backup Device Interface API. At this time, only system admins can make
calls
> with this interface. Backup Operators do not.
> Sincerely,
>
> Anthony Thomas
>
> "Tibor Karaszi" wrote:
> > What does the documentation for the backup vendor say? Does it say that
the login need to be
> > sysadmin. If not, you have a bug in their program. If it does, well...
> >
> > You cannot grant permissions on this. Also, this is an undocumented
command, so the backup vendor is
> > using it at their own risk.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> > news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> > > Hello,
> > >
> > > I´m testing the execution of my database backups with omniback. These
> > > backups fails so i've made a trace and i get the following error:
"Error:
> > > 7983, Severity: 14, State: 14"
> > > "dbcc showfilestats( 1 )"
> > >
> > > The user used to access the databases is a domain admin but in sql
server i
> > > only give him the backup operator database role.
> > > If this user were sysadmin everything goes fine but i want to limit
his
> > > access.
> > >
> > > Do you have any idea about this?
> > >
> >
> >
> >sql
I´m testing the execution of my database backups with omniback. These
backups fails so i've made a trace and i get the following error: "Error:
7983, Severity: 14, State: 14"
"dbcc showfilestats( 1 )"
The user used to access the databases is a domain admin but in sql server i
only give him the backup operator database role.
If this user were sysadmin everything goes fine but i want to limit his
access.
Do you have any idea about this?What does the documentation for the backup vendor say? Does it say that the login need to be
sysadmin. If not, you have a bug in their program. If it does, well...
You cannot grant permissions on this. Also, this is an undocumented command, so the backup vendor is
using it at their own risk.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> Hello,
> I´m testing the execution of my database backups with omniback. These
> backups fails so i've made a trace and i get the following error: "Error:
> 7983, Severity: 14, State: 14"
> "dbcc showfilestats( 1 )"
> The user used to access the databases is a domain admin but in sql server i
> only give him the backup operator database role.
> If this user were sysadmin everything goes fine but i want to limit his
> access.
> Do you have any idea about this?
>|||Moreover, the SQL Backup alternatives typically want to use the Virtual
Backup Device Interface API. At this time, only system admins can make calls
with this interface. Backup Operators do not.
Sincerely,
Anthony Thomas
"Tibor Karaszi" wrote:
> What does the documentation for the backup vendor say? Does it say that the login need to be
> sysadmin. If not, you have a bug in their program. If it does, well...
> You cannot grant permissions on this. Also, this is an undocumented command, so the backup vendor is
> using it at their own risk.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> > Hello,
> >
> > I´m testing the execution of my database backups with omniback. These
> > backups fails so i've made a trace and i get the following error: "Error:
> > 7983, Severity: 14, State: 14"
> > "dbcc showfilestats( 1 )"
> >
> > The user used to access the databases is a domain admin but in sql server i
> > only give him the backup operator database role.
> > If this user were sysadmin everything goes fine but i want to limit his
> > access.
> >
> > Do you have any idea about this?
> >
>
>|||That undocumented DBCC command is SA-only - there's no way around this.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:354E62F2-2E58-4D0A-BE1F-E1AA3D8262BE@.microsoft.com...
> Moreover, the SQL Backup alternatives typically want to use the Virtual
> Backup Device Interface API. At this time, only system admins can make
calls
> with this interface. Backup Operators do not.
> Sincerely,
>
> Anthony Thomas
>
> "Tibor Karaszi" wrote:
> > What does the documentation for the backup vendor say? Does it say that
the login need to be
> > sysadmin. If not, you have a bug in their program. If it does, well...
> >
> > You cannot grant permissions on this. Also, this is an undocumented
command, so the backup vendor is
> > using it at their own risk.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "CC&JM" <CC&JM@.discussions.microsoft.com> wrote in message
> > news:A094D1B4-135A-492B-ADAC-2C12CB9CAC35@.microsoft.com...
> > > Hello,
> > >
> > > I´m testing the execution of my database backups with omniback. These
> > > backups fails so i've made a trace and i get the following error:
"Error:
> > > 7983, Severity: 14, State: 14"
> > > "dbcc showfilestats( 1 )"
> > >
> > > The user used to access the databases is a domain admin but in sql
server i
> > > only give him the backup operator database role.
> > > If this user were sysadmin everything goes fine but i want to limit
his
> > > access.
> > >
> > > Do you have any idea about this?
> > >
> >
> >
> >sql
Friday, February 24, 2012
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...
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...
http://www.sql-server-performance.c...cumented_dbcc.a
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...
http://www.sql-server-performance.c...cumented_dbcc.a
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
... 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:|||Hi,
> Anyone knows of any good source of DBCC commands (not the usual ones
> ... the hindden commands), and TRACE flags?
> TIA
> Pablo
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:|||Be very careful using undocumented (and hence unsupported) DBCC commands -
> 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...
>
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:|||Paul S Randal [MS] wrote:
> 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:
> 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 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
... 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
Subscribe to:
Posts (Atom)