ErrorLog Is Your Friend!
Dec 22, 2005
I just spent the better part of a full day trying to figure out why my MSSQLSERVER service wouldn't start. Finally, after someone suggested I check out "C:Program FilesMicrosoft SQL Server[Instance Name]LogErrorLog" I found my problem. I opened it up to find: (newbie mistake, I know now!!)
2005-12-21 19:27:46.60 server SQL Server evaluation period has expired
So I thought I would pass this onto everyone I can think of so you will not make the mistake I just did.
It would have been nice if Microsoft, like just about every other software company out there, would have been loud & obnoxious about their trial software expiring. Instead they have to put a poor newbie soul thru what I just went thru.
*sigh*
Well if I helped 1 person with this, I've done some good!
View 1 Replies
ADVERTISEMENT
Jun 14, 2001
Hello all,
I don't know what I am doing wrong.
In my environment, we have monitoring tool that scan through sql errorlog
every 10minutes to capture some error that occurs.
I have been trying for days now to create an alert for any of our failed
backup to appear in the sql errorlog with the code below. After I add
message to the sysmessage table with sp_addmessage, and raising the error
with log option, I modified the existing scheduled backup job by creating
an alert with the num in the code.
For some reason, this error will not just show up in the sql errorlog when
it failed.
Has anyone any advise on what to do?
The code is:
sp_addmessage 50001, 25, 'Backup Failed for the '%.*ls' database.Please Contact MSSQL DBA Immediately!!!! '
GO
DECLARE @DBID INT
SET @DBID = DB_ID()
DECLARE @DBNAME NVARCHAR(128)
SET @DBNAME = DB_NAME()
RAISERROR (50001, 25, 1, @DBID, @DBNAME) with log
GO
Thanks
SA
View 1 Replies
View Related
Apr 18, 2008
Greetings,
I'm trying to come up with a way (efficiency isn't the most important thing here) ..to show how a person is related to another person on my website. The table structure is like so (simplified)
ID | UserName| FriendName
1 | Danny | Mike2 | Mike | Danny3 | Steve | Jason4 | Jason | Steve5 | Steve Danny6 | Danny | Steve
There are 2 rows each for every 'relationship' - I chose this design to simplify queries like "give me all of danny's friends" etc.
With this stucture, I want to be able to display to a user how they are "related" to someone that they may not necessarily be friends with. For example, lets say you are logged in as "Jason" and you are looking at "Dannys" homepage.
You are not Danny's friend..but you are related to him through Steve (because you are a friend of steve, and steve is a friend of jason)
I'm stumped trying to come up with a decent way to get this type of information..either in a sproc...or doing it in the business layer (c#). I think recursion is the way to go, and I could limit it to 4,5,6 levels whatever... again, efficiency isn't an issue here...I just want to somehow pull the data cleanly.
Any ideas?
View 5 Replies
View Related
May 18, 2008
Hi im finalizing a site for a custmer and now adding a Tell a friend function. I have done those before but not when storing the mailmessage in the SQL server and my question is
How do I build this up in a good way...I have done the mailsender and its sends the email but how do I bind it together...
I have two columns comming in a single row dataset from the Database:
MailSubjectMailBody
I dont want to bind it to a gridview or another control and then fetch that to my mail message
Public Function TellaFriend(ByVal strEmail As String, ByVal strMyName As String, ByVal cultureid As Integer) As String
'Tell a friend Dim Data As DAL Data = New DAL Dim dsEmail As DataSet = Data.GetEmailMessage(1, cultureid) MyMailMessage.From = New MailAddress(info@company.com, "Customer Service") MyMailMessage.To.Add(New MailAddress(strEmail, "Hint from a friend" & strMyName)) MyMailMessage.Subject = dsEmail("MailSubject") MyMailMessage.IsBodyHtml = False MyMailMessage.Body = dsEmail("MailBody") 'Create the SMTPClient object and DO NOT specify the SMTP server name Dim SMTPServer As New SmtpClient() Dim MailSent As String
Try SMTPServer.Send(MyMailMessage) MailSent = "True" Catch ex As SmtpException MailSent = "False" End Try Return MailSentEnd Function
Of course this doesnt work but what do I need to do to bind Data.GetEmailMessage(1, cultureid) without using a gridview or any other datapresentation control directly in this function?
If you need it this is from my DALFunction GetEmailMessage(ByVal intMessageId As Integer, ByVal intCultureId As Integer) As DataSet
Dim DS As DataSetDim objConn As SqlConnectionDim objCmd As SqlDataAdapter
objConn = New SqlConnection(_connStr)objCmd = New SqlDataAdapter("sp_GetEmailMessage", objConn)objCmd.SelectCommand.CommandType = CommandType.StoredProcedureobjCmd.SelectCommand.Parameters.Add(New SqlParameter("@messageid", SqlDbType.Int))objCmd.SelectCommand.Parameters("@messageid").Value = intMessageIdobjCmd.SelectCommand.Parameters.Add(New SqlParameter("@cultureid", SqlDbType.Int))objCmd.SelectCommand.Parameters("@cultureid").Value = intCultureIdDS = New DataSet()objCmd.Fill(DS, "dsMailMessage")Return DSEnd FunctionThanks,
View 7 Replies
View Related
Aug 14, 2000
Hi!
Even though i see all the errorlog files physically stored in the log directory, I am not seeing any errorlog info on Enterprice Manager. I see all files like errorlog, errorlog1, errorlog2, etc, when i click current errorlog, it shows nothing, Please help me what could be the problem?
Appreciate all your ideas.
Mohan
View 1 Replies
View Related
Dec 9, 1998
what does the error "login failed-User: Reason : Not associated with a trusted
SQL Server connection" means in the errorlog? it keeps on writing in the errorlog. what could be the caused of this? and how to correct this?
thanks a lot!
View 1 Replies
View Related
Sep 25, 2003
Hi....Does anyone know if there is a similar command to SQL2K's DBCC ERRORLOG.
I'm currently writing a preventative maintenance script and want to force archiving of errorlogs. Any help greatly appreciated.
View 3 Replies
View Related
Aug 13, 2002
Hello-
I am getting a recurring error in my errorlog. This is the error:
"BlkHeader from strip 0 At 13531e00 ExpectedAt 13531e00 Size c00 PrevSize 200"
Has anyone seen this before?
Thanks,
Traci McPartland
View 2 Replies
View Related
Apr 20, 2004
I am trying to change the default number of SQL errorlogs from 6 to 12. Does anyone know how to change that?
View 7 Replies
View Related
Sep 17, 2001
I need to move the errorlog files from the d: drive to the e: drive on my NT servers. Does anyone know a way to accomplish this without having to re-install?
Thanks
tcb
View 2 Replies
View Related
Jan 19, 2000
We're running SQL 6.5 SP3, we recycle our SQL server every day, somehow starting last December, the errorlog kept appending to the previous one
without starting a new log, and it keeps on growing,
any one knows anywhere I should look into ?
If SQL behaves properly, it should starts a new log after each recycle.
I checked from Technet this problem may occur in 4.2 but I haven't seen anything in 6.5....Thanks
Anthony
View 3 Replies
View Related
Nov 2, 2004
Considering email is setup, how would you send emails by scanning errorlog for any issues. Also, how to send program outputs using email.
Thanks
View 4 Replies
View Related
Sep 6, 2006
Hi.
I have a service on a server which contains Sql Server Express.
this service adds documents to the database to allow full text search features.
From some reason, the index crashes and than it writes to the ErrorLog file, the errorlog jumps to 20GB(!) causing the server to crash.
How can :
1. limit the size of the error log.
2. find out why the log jumps to this size (I can't open the error log file ofcourse...)
Thanks!
View 5 Replies
View Related
Aug 4, 1999
Hi,
How print out a readable dump by using PRINTDMP, I didn't catch up the
parameters that I have to pass.
Thanks,
Herve Meftah
View 1 Replies
View Related
Feb 28, 2008
We have set up a couple of SQL Server 2005 systems and I have foundthat the format of the ERRORLOG files and the SQL Agent's log filesare Unicode or some format that findstr cannot parse properly. "find"parses them fine, but it doesn't have the capabilities that I need --specifically, I can't search for multiple strings in one search.I see the checkbox on the SQL Agent's for "Write OEM File", but it isgrayed out so I am not able to try checking that. I also don't knowif that would affect the server's ERRORLOG file too or just theAgent's log file.So what am I missing? What is everyone else doing who is used tohaving scripts to parse these files looking for strings that indicateproblems? Is there a server setting that will force it to go back toa plain ANSI text file format for log files? Is that a bad thing todo?Thanks in advance for any insight,Teresa Masino
View 4 Replies
View Related
Dec 1, 2004
Hi
I was not able to connect to SQL Server machine. On examining the Error log (which was huge 53MB), I found the following messages that filled 95% of the logfile. Is this something to do with memory allocation.
Someone, please let me know what is going on. After the server reboot everything works fine.
I am worrired that this message may occur again.
Thanks
Machilu
2004-11-30 20:15:03.64 logon Login failed for user 'NT AUTHORITYSYSTEM'
2004-12-01 08:15:03.77 logon Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
2004-12-01 00:47:25.28 spid70 WARNING: Failed to reserve contiguous memory of Size= 65536.
2004-12-01 00:47:25.31 spid70 Buffer Distribution: Stolen=127590 Free=4176 Procedures=182443
Inram=0 Dirty=14180 Kept=0
I/O=0, Latched=154, Other=10049
2004-12-01 00:47:25.31 spid70 Buffer Counts: Commited=338592 Target=338592 Hashed=24383
InternalReservation=357 ExternalReservation=0 Min Free=256
2004-12-01 00:47:25.31 spid70 Procedure Cache: TotalProcs=66212 TotalPages=182443 InUsePages=88547
2004-12-01 00:47:25.31 spid70 Dynamic Memory Manager: Stolen=310033 OS Reserved=38512
OS Committed=38457
OS In Use=38388
Query Plan=332158 Optimizer=0
General=15540
Utilities=8 Connection=473
2004-12-01 00:47:25.31 spid70 Global Memory Objects: Resource=10685 Locks=119
SQLCache=4540 Replication=2
LockBytes=2 ServerGlobal=45
Xact=201
2004-12-01 00:47:25.31 spid70 Query Memory Manager: Grants=0 Waiting=0 Maximum=92118 Available=92118
2004-12-01 00:50:04.10 logon Login failed for user 'NT AUTHORITYSYSTEM'.
2004-12-01 00:50:04.32 logon Login failed for user 'NT AUTHORITYSYSTEM'.
2004-12-01 00:51:08.78 spid70 WARNING: Failed to reserve contiguous memory of Size= 65536.
2004-12-01 00:51:08.82 spid70 Buffer Distribution: Stolen=138829 Free=5944 Procedures=169283
Inram=0 Dirty=14431 Kept=0
I/O=0, Latched=154, Other=9951
2004-12-01 00:51:08.82 spid70 Buffer Counts: Commited=338592 Target=338592 Hashed=24536
InternalReservation=360 ExternalReservation=0 Min Free=256
2004-12-01 00:51:08.82 spid70 Procedure Cache: TotalProcs=67783 TotalPages=169283 InUsePages=76116
2004-12-01 00:51:08.82 spid70 Dynamic Memory Manager: Stolen=308112 OS Reserved=38512
OS Committed=38457
OS In Use=38398
Query Plan=330249 Optimizer=0
General=15535
Utilities=8 Connection=476
2004-12-01 00:51:08.82 spid70 Global Memory Objects: Resource=10685 Locks=118
SQLCache=4540 Replication=2
LockBytes=2 ServerGlobal=45
Xact=202
View 4 Replies
View Related
Feb 22, 2005
Hi, all
recently, I use the following script(somebody else) to create a database on a remote server: the script is as follow:
/*************************/
CREATE DATABASE [ErrorLog]
GO
Use ErrorLog
CREATE TABLE [dbo].[Errors] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[SessionID] [char] (12) NULL ,
[RequestMethod] [char] (5) NULL ,
[ServerPort] [char] (5) NULL ,
[HTTPS] [char] (3) NULL ,
[LocalAddr] [char] (15) NULL ,
[HostAddress] [char] (15) NULL ,
[UserAgent] [varchar] (255) NULL ,
[URL] [varchar] (400) NULL ,
[CustomerRefID] [varchar] (20) NULL ,
[FormData] [varchar] (2000),
[AllHTTP] [varchar] (2000),
[ErrASPCode] [char] (10) NULL ,
[ErrNumber] [char] (11) NULL ,
[ErrSource] [varchar] (255) NULL ,
[ErrCategory] [varchar] (50) NULL ,
[ErrFile] [varchar] (255) NULL ,
[ErrLine] [int] NULL ,
[ErrColumn] [int] NULL,
[ErrDescription] [varchar] (1000) NULL ,
[ErrAspDescription] [varchar] (1000) NULL ,
[InsertDate] [datetime] NOT NULL
) ON [PRIMARY]
--Create the user "ErrorLog"
if not exists (select * from master.dbo.syslogins where loginname = N'ErrorLog')
BEGIN
declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Navigator', @loginlang = N'us_english'
if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
select @logindb = N'master'
if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
select @loginlang = @@language
exec sp_addlogin N'ErrorLog', 'secret', @logindb, @loginlang
END
GO
if not exists (select * from dbo.sysusers where name = N'ErrorLog' and uid < 16382)
EXEC sp_grantdbaccess N'ErrorLog', N'ErrorLog'
GO
Grant select, insert On Errors to ErrorLog
/***************************/
in my *.asp program, I used the following string to connect to the database on the remote server.
/********
con.open "dsn=ErrorLog;uid=ErrorLog;pwd=secret;"
********/
the following message comes up:
/********/
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ErrorLog'.
/*********/
what is the problem here?
when I set up dsn ErrorLOG, I used "abc" userID and password "XXX" which is our server database administrator assigned to me. I tested connection in odbc, it is OK
I just don't get, ther user ErrorLog already had login id and granted access to database errorlog. any clue, please help!
Betty
View 6 Replies
View Related
