sql server new users:
Hi Roger,
Try recycling the errorlog with stored proc sp_cycle_errorlog, this creates
a new errorlog, and automatically renames the current one to errorlog.<n>
without restarting the database, then open the required error logfile with an
editor as opposed to the EM GUI.
Hope this helps
cheers
[quoted text, click to view] "Roger" wrote:
> I have a log file that is pretty large, but I cannot see it inside
> Enterprise manager. It just shows an hourglass when I click on the log.
>
> I would like to see even part of it if possible.
>
> Where do I look for the file and what do I use to possibly copy 10% of the
> file?
>
> Thanks,
>
> Roger
>
>
I have a log file that is pretty large, but I cannot see it inside
Enterprise manager. It just shows an hourglass when I click on the log.
I would like to see even part of it if possible.
Where do I look for the file and what do I use to possibly copy 10% of the
file?
Thanks,
Roger
Hi,
The "default" path to that file will be in \\install folder\ Program
files\microsoft sql server\Log folder. Latest file will be ERRORLOG (with
out a number).
If you dont see the file then do a search for the file "ERRORLOG" .
Once you find the file just right click and open in Notepad.
Thanks
Hari
SQL Server MVP
[quoted text, click to view] "Roger" <rogoflap@gmail.com> wrote in message
news:u1JuAviqFHA.3644@TK2MSFTNGP10.phx.gbl...
>I have a log file that is pretty large, but I cannot see it inside
> Enterprise manager. It just shows an hourglass when I click on the log.
>
> I would like to see even part of it if possible.
>
> Where do I look for the file and what do I use to possibly copy 10% of the
> file?
>
> Thanks,
>
> Roger
>
>
