Friday, February 24, 2012

Change SQL Server Error Logs

How do I change the number of SQL Server Error Logs from
the default of six?
Thank You,
DeanThis is a multi-part message in MIME format.
--=_NextPart_000_01C3_01C3ADC3.83BDD530
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
In EM, go to Management->SQL Server Logs->Configure and then set the number
you want.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:06be01c3adec$d11d95d0$a001280a@.phx.gbl...
How do I change the number of SQL Server Error Logs from
the default of six?
Thank You,
Dean
--=_NextPart_000_01C3_01C3ADC3.83BDD530
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

In EM, go to Management->SQL Server =Logs->Configure and then set the number you want.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Dean" wrote in message news:06be01c3adec$d1=1d95d0$a001280a@.phx.gbl...How do I change the number of SQL Server Error Logs from the default of six?Thank You,Dean

--=_NextPart_000_01C3_01C3ADC3.83BDD530--|||This is a multi-part message in MIME format.
--=_NextPart_000_0042_01C3ADCB.31C905D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Mine always defaults back to 6. Any way to change this?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:%23ALDx1erDHA.1872@.TK2MSFTNGP09.phx.gbl...
In EM, go to Management->SQL Server Logs->Configure and then set the =number you want.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dean" <anonymous@.discussions.microsoft.com> wrote in message =news:06be01c3adec$d11d95d0$a001280a@.phx.gbl...
How do I change the number of SQL Server Error Logs from the default of six?
Thank You,
Dean
--=_NextPart_000_0042_01C3ADCB.31C905D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Mine always defaults back to 6. Any way =to change this?
"Tom Moreau" = wrote in message news:%23ALDx1erDHA.=1872@.TK2MSFTNGP09.phx.gbl...
In EM, go to Management->SQL =Server Logs->Configure and then set the number you want.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"Dean" wrote in message news:06be01c3adec$d1=1d95d0$a001280a@.phx.gbl...How do I change the number of SQL Server Error Logs from the default =of six?Thank You,Dean

--=_NextPart_000_0042_01C3ADCB.31C905D0--|||This is a multi-part message in MIME format.
--=_NextPart_000_028C_01C3ADD0.9F7BA830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Are you a member of the sysadmin role?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Greg" <toonanimator@.excite.com> wrote in message
news:ukI8bUfrDHA.2556@.TK2MSFTNGP09.phx.gbl...
Mine always defaults back to 6. Any way to change this?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23ALDx1erDHA.1872@.TK2MSFTNGP09.phx.gbl...
In EM, go to Management->SQL Server Logs->Configure and then set the
number you want.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:06be01c3adec$d11d95d0$a001280a@.phx.gbl...
How do I change the number of SQL Server Error Logs from
the default of six?
Thank You,
Dean
--=_NextPart_000_028C_01C3ADD0.9F7BA830
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Are you a member of the sysadmin role?
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Greg" =wrote in message news:ukI8bUfrDHA.2556=@.TK2MSFTNGP09.phx.gbl...
Mine always defaults back to 6. Any way =to change this?
"Tom Moreau" = wrote in message news:%23ALDx1erDHA.=1872@.TK2MSFTNGP09.phx.gbl...
In EM, go to Management->SQL =Server Logs->Configure and then set the number you want.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"Dean" wrote in message news:06be01c3adec$d1=1d95d0$a001280a@.phx.gbl...How do I change the number of SQL Server Error Logs from the default =of six?Thank You,Dean

--=_NextPart_000_028C_01C3ADD0.9F7BA830--

No comments:

Post a Comment