Activating Server Logs

I have two remote Win2000 servers running SQL2000. There are no items under
SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log database
activity?
Thanks,
John Steen
remove (nospam) from e-mail address to send me a messageNever heard we must activate something for the log. What do you see in
\Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
named ERRORLOG.
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>I have two remote Win2000 servers running SQL2000. There are no items
>under
> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> database
> activity?
> Thanks,
> John Steen
> remove (nospam) from e-mail address to send me a message|||Hi
SQL Server does not log activity like inserts and deletes. You need to run
SQL Server Profiler to do that.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ME" <ME@.hotmail.com> wrote in message
news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> files named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>|||My bad. Didn't read the last part of the post.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ugABXMVYFHA.2572@.TK2MSFTNGP14.phx.gbl...
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
>> files named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>>
>|||There are log files in the log folder, but the latest one is dated May 17,
2004, which is around the time they were moved there from the location where
they were set up. The IP addresses were also changed when they were moved to
their current location. I don't what else may have changed.
Could that have something to do with why the logs stopped recording?
Thanks,
John
"ME" wrote:
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >I have two remote Win2000 servers running SQL2000. There are no items
> >under
> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> > database
> > activity?
> >
> > Thanks,
> > John Steen
> > remove (nospam) from e-mail address to send me a message
>
>|||I'm not trying to log inserts and such, Mike, just normal DB activtiy
(startups, shutdowns, recoveries, DBCC jobs, etc.) you see in the server logs.
Thanks,
John
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> > Never heard we must activate something for the log. What do you see in
> > \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> > files named ERRORLOG.
> >
> >
> > "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> > news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >>I have two remote Win2000 servers running SQL2000. There are no items
> >>under
> >> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> database
> >> activity?
> >>
> >> Thanks,
> >> John Steen
> >> remove (nospam) from e-mail address to send me a message
> >
> >
>
>|||Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
path that the parameter points to.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> There are log files in the log folder, but the latest one is dated May 17,
> 2004, which is around the time they were moved there from the location where
> they were set up. The IP addresses were also changed when they were moved to
> their current location. I don't what else may have changed.
> Could that have something to do with why the logs stopped recording?
> Thanks,
> John
> "ME" wrote:
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
>> named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>> >I have two remote Win2000 servers running SQL2000. There are no items
>> >under
>> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> > database
>> > activity?
>> >
>> > Thanks,
>> > John Steen
>> > remove (nospam) from e-mail address to send me a message
>>|||Thanks, Tibor, that did it!
John
"Tibor Karaszi" wrote:
> Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
> path that the parameter points to.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> > There are log files in the log folder, but the latest one is dated May 17,
> > 2004, which is around the time they were moved there from the location where
> > they were set up. The IP addresses were also changed when they were moved to
> > their current location. I don't what else may have changed.
> >
> > Could that have something to do with why the logs stopped recording?
> >
> > Thanks,
> > John
> >
> > "ME" wrote:
> >
> >> Never heard we must activate something for the log. What do you see in
> >> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> >> named ERRORLOG.
> >>
> >>
> >> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> >> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >> >I have two remote Win2000 servers running SQL2000. There are no items
> >> >under
> >> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> > database
> >> > activity?
> >> >
> >> > Thanks,
> >> > John Steen
> >> > remove (nospam) from e-mail address to send me a message
> >>
> >>
> >>
>
>