July 12, 2012 at 2:16 pm
Hi.....guys........
Error:
2012-07-10 00:06:57.73 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)
2012-07-10 00:06:57.73 server Copyright (C) 1988-2002 Microsoft Corporation.
2012-07-10 00:06:57.73 server All rights reserved.
2012-07-10 00:06:57.73 server Server Process ID is 3160.
2012-07-10 00:06:57.73 server Logging SQL Server messages in file 'M:\Program Files\Microsoft SQL Server\MSSQL$CITRIX_METAFRAME\LOG\ERRORLOG'.
2012-07-10 00:06:57.79 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2012-07-10 00:06:58.06 server SQL Server configured for thread mode processing.
2012-07-10 00:06:58.06 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2012-07-10 00:06:58.10 spid2 Starting up database 'master'.
2012-07-10 00:06:58.21 server Using 'SSNETLIB.DLL' version '8.0.766'.
2012-07-10 00:06:58.21 spid5 Starting up database 'model'.
2012-07-10 00:06:58.23 spid2 Server name is 'CITRIX3\CITRIX_METAFRAME'.
2012-07-10 00:06:58.23 spid2 Skipping startup of clean database id 4
2012-07-10 00:06:58.23 spid2 Starting up database 'MF20'.
2012-07-10 00:06:58.26 server SQL server listening on 10.127.0.13: 1654.
2012-07-10 00:06:58.26 server SQL server listening on 127.0.0.1: 1654.
2012-07-10 00:06:58.32 server SQL server listening on TCP, Shared Memory, Named Pipes.
2012-07-10 00:06:58.32 server SQL Server is ready for client connections
2012-07-10 00:06:58.35 spid2 Recovery is checkpointing database 'MF20' (5)
2012-07-10 00:06:58.45 spid5 Clearing tempdb database.
2012-07-10 00:06:58.70 spid5 Starting up database 'tempdb'.
2012-07-10 00:06:58.71 spid2 Recovery complete.
2012-07-10 00:06:58.71 spid2 SQL global counter collection task is created.
2012-07-10 00:07:22.93 spid51 Starting up database 'MF20'.
2012-07-11 09:20:29.12 spid55 Starting up database 'msdb'.
2012-07-11 09:20:31.87 spid5 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2012-07-11 09:20:32.95 spid52 Database MF20: IO is frozen for snapshot
2012-07-11 09:20:32.95 spid53 Database model: IO is frozen for snapshot
2012-07-11 09:20:32.95 spid55 Database msdb: IO is frozen for snapshot
2012-07-11 09:20:32.95 spid54 Database master: IO is frozen for snapshot
2012-07-11 09:20:33.70 spid55 Database msdb: IO is thawed
2012-07-11 09:20:33.70 spid52 Database MF20: IO is thawed
2012-07-11 09:20:33.70 spid53 Database model: IO is thawed
2012-07-11 09:20:33.70 spid54 Database master: IO is thawed
2012-07-11 09:20:33.74 backup Database backed up: Database: MF20, creation date(time): 2007/02/01(13:16:03), pages dumped: 1, first LSN: 4649:74:1, last LSN: 4649:77:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{847B2624-A012-44A9-8935-C7770E27C5C1}1'}).
2012-07-11 09:20:33.74 backup Database backed up: Database: msdb, creation date(time): 2002/12/17(14:41:12), pages dumped: 1, first LSN: 120:304:1, last LSN: 120:306:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{847B2624-A012-44A9-8935-C7770E27C5C1}3'}).
2012-07-11 09:20:33.74 backup Database backed up: Database: master, creation date(time): 2012/07/10(00:06:58), pages dumped: 1, first LSN: 109:300:1, last LSN: 109:303:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{847B2624-A012-44A9-8935-C7770E27C5C1}4'}).
2012-07-11 09:20:33.74 backup Database backed up: Database: model, creation date(time): 2002/12/17(14:36:05), pages dumped: 1, first LSN: 22:29:1, last LSN: 22:31:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{847B2624-A012-44A9-8935-C7770E27C5C1}2'}).
2012-07-11 09:21:31.87 spid9 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2012-07-11 09:27:01.88 spid12 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 2 queries and performance may be adversely affected.
2012-07-11 09:27:04.05 spid52 Database MF20: IO is frozen for snapshot
2012-07-11 09:27:04.05 spid53 Database model: IO is frozen for snapshot
2012-07-11 09:27:04.07 spid54 Database msdb: IO is frozen for snapshot
2012-07-11 09:27:04.07 spid55 Database master: IO is frozen for snapshot
2012-07-11 09:27:04.75 spid52 Database MF20: IO is thawed
2012-07-11 09:27:04.75 spid53 Database model: IO is thawed
2012-07-11 09:27:04.75 spid54 Database msdb: IO is thawed
2012-07-11 09:27:04.75 spid55 Database master: IO is thawed
2012-07-11 09:27:04.79 backup Database backed up: Database: model, creation date(time): 2002/12/17(14:36:05), pages dumped: 1, first LSN: 22:34:1, last LSN: 22:36:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8B6E581B-31CE-4053-859D-8F85C96AA36C}2'}).
2012-07-11 09:27:04.79 backup Database backed up: Database: MF20, creation date(time): 2007/02/01(13:16:03), pages dumped: 1, first LSN: 4649:80:1, last LSN: 4649:82:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8B6E581B-31CE-4053-859D-8F85C96AA36C}1'}).
2012-07-11 09:27:04.79 backup Database backed up: Database: msdb, creation date(time): 2002/12/17(14:41:12), pages dumped: 1, first LSN: 120:335:1, last LSN: 120:338:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8B6E581B-31CE-4053-859D-8F85C96AA36C}3'}).
2012-07-11 09:27:04.79 backup Database backed up: Database: master, creation date(time): 2012/07/10(00:06:58), pages dumped: 1, first LSN: 109:306:1, last LSN: 109:308:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8B6E581B-31CE-4053-859D-8F85C96AA36C}4'}).
2012-07-11 09:28:01.88 spid5 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2012-07-11 09:29:06.88 spid9 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 3 queries and performance may be adversely affected.
2012-07-11 09:29:06.92 spid53 Database MF20: IO is frozen for snapshot
2012-07-11 09:29:06.92 spid52 Database model: IO is frozen for snapshot
2012-07-11 09:29:06.92 spid54 Database msdb: IO is frozen for snapshot
2012-07-11 09:29:06.92 spid55 Database master: IO is frozen for snapshot
2012-07-11 09:29:07.62 spid53 Database MF20: IO is thawed
2012-07-11 09:29:07.62 spid52 Database model: IO is thawed
2012-07-11 09:29:07.62 spid55 Database master: IO is thawed
2012-07-11 09:29:07.62 spid54 Database msdb: IO is thawed
2012-07-11 09:29:07.87 backup Database backed up: Database: model, creation date(time): 2002/12/17(14:36:05), pages dumped: 1, first LSN: 22:39:1, last LSN: 22:41:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{2F968722-D4A7-478D-8A4E-F37844B6F61E}2'}).
2012-07-11 09:29:07.87 backup Database backed up: Database: MF20, creation date(time): 2007/02/01(13:16:03), pages dumped: 1, first LSN: 4649:85:1, last LSN: 4649:87:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{2F968722-D4A7-478D-8A4E-F37844B6F61E}1'}).
2012-07-11 09:29:07.87 backup Database backed up: Database: msdb, creation date(time): 2002/12/17(14:41:12), pages dumped: 1, first LSN: 120:362:1, last LSN: 120:365:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{2F968722-D4A7-478D-8A4E-F37844B6F61E}3'}).
2012-07-11 09:29:07.88 backup Database backed up: Database: master, creation date(time): 2012/07/10(00:06:58), pages dumped: 1, first LSN: 109:311:1, last LSN: 109:313:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{2F968722-D4A7-478D-8A4E-F37844B6F61E}4'}).
2012-07-11 09:31:37.78 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.
What does this error means?
Reply....thnx
July 12, 2012 at 2:29 pm
I don't see an error in that log output. I must be missing it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 2:35 pm
MSDE is tuned for up to 8 concurrent queries, you are exceeding that, you would need to upgrade to a higher edition.
---------------------------------------------------------------------
July 12, 2012 at 2:40 pm
Saggy (7/12/2012)
2012-07-11 09:31:37.78 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.
No error. Someone stopped the service.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2012 at 2:50 pm
lets play guess the error........:-)
which message actually concerns you saggy?
---------------------------------------------------------------------
July 12, 2012 at 2:54 pm
This one
Database master: IO is frozen for snapshot
or this one
Database MF20: IO is thawed
Those can be caused by any number of backup agents (such as Windows NT backup).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply