Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server 2000 ErrorLog

Author  Topic 

rikleo2001
Posting Yak Master

185 Posts
Posted - 2007-06-07 : 18:53:54
Guys,

I am running SQL Server 2000 SP4 on VMWARE w2003 Server SP1.
My database is on Simple Recovery Mode.
my Network department taking backup using Symentic LiveState on regular basis.

In past I ignore those Messages (Below), but now I need you advice, that Frozen Databases and Backup of database occuring quite often, is that could cause any issue in regards to performance?

What prcocess is generating those Logs?

Any help greatly appreciated. Thanks in advance.


2007-06-07 03:35:44.30 spid58 Database model: IO is frozen for snapshot
2007-06-07 03:35:44.30 spid62 Database msdb: IO is frozen for snapshot
2007-06-07 03:35:44.30 spid70 Database pubs: IO is frozen for snapshot
2007-06-07 03:35:44.31 spid68 Database Northwind: IO is frozen for snapshot
2007-06-07 03:35:44.31 spid67 Database CalibaCoreData: IO is frozen for snapshot
2007-06-07 03:35:44.31 spid61 Database Fetch_Sales: IO is frozen for snapshot
2007-06-07 03:35:44.31 spid66 Database Tempo: IO is frozen for snapshot
2007-06-07 03:35:44.31 spid60 Database Admin_Routine: IO is frozen for snapshot
2007-06-07 03:35:44.47 spid65 Database VersionManagementSystem: IO is frozen for snapshot
2007-06-07 03:35:44.47 spid64 Database EmailXtender: IO is frozen for snapshot
2007-06-07 03:35:44.47 spid69 Database ExAudit: IO is frozen for snapshot
2007-06-07 03:35:44.47 spid63 Database CON_X_Coredata: IO is frozen for snapshot
2007-06-07 03:35:44.47 spid57 Database master: IO is frozen for snapshot
2007-06-07 03:35:44.66 spid63 Database CON_X_Coredata: IO is thawed
2007-06-07 03:35:44.67 spid69 Database ExAudit: IO is thawed
2007-06-07 03:35:44.67 spid64 Database EmailXtender: IO is thawed
2007-06-07 03:35:44.67 spid65 Database VersionManagementSystem: IO is thawed
2007-06-07 03:35:44.67 spid60 Database Admin_Routine: IO is thawed
2007-06-07 03:35:44.67 spid66 Database Tempo: IO is thawed
2007-06-07 03:35:44.67 spid61 Database Fetch_Sales: IO is thawed
2007-06-07 03:35:44.67 spid67 Database CalibaCoreData: IO is thawed
2007-06-07 03:35:44.67 spid68 Database Northwind: IO is thawed
2007-06-07 03:35:44.67 spid70 Database pubs: IO is thawed
2007-06-07 03:35:44.67 spid62 Database msdb: IO is thawed
2007-06-07 03:35:44.67 spid58 Database model: IO is thawed
2007-06-07 03:35:44.67 spid57 Database master: IO is thawed
2007-06-07 03:35:44.97 backup Database backed up: Database: master, creation date(time): 2007/06/07(00:30:09), pages dumped: 1, first LSN: 177:426:1, last LSN: 177:428:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}1'}).
2007-06-07 03:35:44.99 backup Database backed up: Database: CON_X_Coredata, creation date(time): 2007/04/14(15:15:31), pages dumped: 1, first LSN: 262:2073:1, last LSN: 262:2075:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}13'}).
2007-06-07 03:35:45.00 backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52), pages dumped: 1, first LSN: 12:330:1, last LSN: 12:332:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}2'}).
2007-06-07 03:35:45.00 backup Database backed up: Database: Admin_Routine, creation date(time): 2007/01/28(17:30:42), pages dumped: 1, first LSN: 14:352:1, last LSN: 14:354:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}9'}).
2007-06-07 03:35:45.00 backup Database backed up: Database: ExAudit, creation date(time): 2007/03/05(15:14:15), pages dumped: 1, first LSN: 14:245:1, last LSN: 14:247:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}12'}).
2007-06-07 03:35:45.00 backup Database backed up: Database: VersionManagementSystem, creation date(time): 2006/11/21(16:40:09), pages dumped: 1, first LSN: 13:190:1, last LSN: 13:192:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}10'}).
2007-06-07 03:35:45.00 backup Database backed up: Database: pubs, creation date(time): 2000/08/06(01:40:58), pages dumped: 1, first LSN: 12:164:1, last LSN: 12:166:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}4'}).
2007-06-07 03:35:45.00 backup Database backed up: Database: CalibaCoreData, creation date(time): 2006/11/04(17:47:08), pages dumped: 1, first LSN: 51:80:1, last LSN: 51:82:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}6'}).
2007-06-07 03:35:45.02 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1, first LSN: 915:106:1, last LSN: 915:109:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}3'}).
2007-06-07 03:35:45.02 backup Database backed up: Database: Fetch_Sales, creation date(time): 2006/11/04(17:47:39), pages dumped: 1, first LSN: 18:131:1, last LSN: 18:133:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}7'}).
2007-06-07 03:35:45.02 backup Database backed up: Database: Northwind, creation date(time): 2000/08/06(01:41:00), pages dumped: 1, first LSN: 30:162:1, last LSN: 30:164:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}5'}).
2007-06-07 03:35:45.02 backup Database backed up: Database: EmailXtender, creation date(time): 2007/03/05(15:14:12), pages dumped: 1, first LSN: 14:321:1, last LSN: 14:323:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}11'}).
2007-06-07 03:35:45.02 backup Database backed up: Database: Tempo, creation date(time): 2006/11/04(17:48:03), pages dumped: 1, first LSN: 3965:449:1, last LSN: 3965:451:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{8DDDEA30-DFE8-439E-8057-02285C0448F8}8'}).
2007-06-07 06:30:20.11 spid62 Database DLG_2004: IO is frozen for snapshot
2007-06-07 06:30:20.11 spid63 Database DLG_2005: IO is frozen for snapshot
2007-06-07 06:30:20.11 spid64 Database DialogCoreData: IO is frozen for snapshot
2007-06-07 06:30:20.11 spid65 Database DLG_2006: IO is frozen for snapshot
2007-06-07 06:30:20.40 spid62 Database DLG_2004: IO is thawed
2007-06-07 06:30:20.40 spid65 Database DLG_2006: IO is thawed
2007-06-07 06:30:20.40 spid64 Database DialogCoreData: IO is thawed
2007-06-07 06:30:20.40 spid63 Database DLG_2005: IO is thawed
2007-06-07 06:30:20.55 backup Database backed up: Database: DialogCoreData, creation date(time): 2007/01/28(17:37:05), pages dumped: 1, first LSN: 766057:3235:1, last LSN: 766057:3250:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1C5267E4-E2A7-4FA9-B3C4-73547AB16FDA}3'}).
2007-06-07 06:30:20.55 backup Database backed up: Database: DLG_2005, creation date(time): 2006/11/04(17:50:16), pages dumped: 1, first LSN: 6388:221:1, last LSN: 6388:223:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1C5267E4-E2A7-4FA9-B3C4-73547AB16FDA}2'}).
2007-06-07 06:30:20.57 backup Database backed up: Database: DLG_2006, creation date(time): 2007/05/03(22:17:43), pages dumped: 1, first LSN: 7350:345:1, last LSN: 7350:347:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1C5267E4-E2A7-4FA9-B3C4-73547AB16FDA}4'}).
2007-06-07 06:30:20.58 backup Database backed up: Database: DLG_2004, creation date(time): 2006/11/04(17:50:03), pages dumped: 1, first LSN: 1743:407:1, last LSN: 1743:409:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1C5267E4-E2A7-4FA9-B3C4-73547AB16FDA}1'}).
2007-06-07 09:15:19.26 spid69 Database model: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid72 Database msdb: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid78 Database pubs: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid71 Database Northwind: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid75 Database CalibaCoreData: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid81 Database Fetch_Sales: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid80 Database Tempo: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid79 Database Admin_Routine: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid85 Database VersionManagementSystem: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid83 Database EmailXtender: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid82 Database ExAudit: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid84 Database CON_X_Coredata: IO is frozen for snapshot
2007-06-07 09:15:19.26 spid70 Database master: IO is frozen for snapshot
2007-06-07 09:15:19.48 spid80 Database Tempo: IO is thawed
2007-06-07 09:15:19.48 spid81 Database Fetch_Sales: IO is thawed
2007-06-07 09:15:19.48 spid84 Database CON_X_Coredata: IO is thawed
2007-06-07 09:15:19.48 spid82 Database ExAudit: IO is thawed
2007-06-07 09:15:19.48 spid83 Database EmailXtender: IO is thawed
2007-06-07 09:15:19.48 spid85 Database VersionManagementSystem: IO is thawed
2007-06-07 09:15:19.48 spid79 Database Admin_Routine: IO is thawed
2007-06-07 09:15:19.48 spid75 Database CalibaCoreData: IO is thawed
2007-06-07 09:15:19.48 spid78 Database pubs: IO is thawed
2007-06-07 09:15:19.48 spid69 Database model: IO is thawed
2007-06-07 09:15:19.48 spid71 Database Northwind: IO is thawed
2007-06-07 09:15:19.48 spid72 Database msdb: IO is thawed
2007-06-07 09:15:19.48 spid70 Database master: IO is thawed
2007-06-07 09:15:20.01 backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52), pages dumped: 1, first LSN: 12:335:1, last LSN: 12:337:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}2'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: Tempo, creation date(time): 2006/11/04(17:48:03), pages dumped: 1, first LSN: 3966:115:1, last LSN: 3966:118:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}8'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: Northwind, creation date(time): 2000/08/06(01:41:00), pages dumped: 1, first LSN: 30:167:1, last LSN: 30:169:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}5'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: CON_X_Coredata, creation date(time): 2007/04/14(15:15:31), pages dumped: 1, first LSN: 262:8793:1, last LSN: 262:8799:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}13'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: ExAudit, creation date(time): 2007/03/05(15:14:15), pages dumped: 1, first LSN: 14:250:1, last LSN: 14:252:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}12'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: VersionManagementSystem, creation date(time): 2006/11/21(16:40:09), pages dumped: 1, first LSN: 13:195:1, last LSN: 13:197:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}10'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: Admin_Routine, creation date(time): 2007/01/28(17:30:42), pages dumped: 1, first LSN: 14:357:1, last LSN: 14:359:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}9'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1, first LSN: 918:312:1, last LSN: 918:315:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}3'}).
2007-06-07 09:15:20.01 backup Database backed up: Database: master, creation date(time): 2007/06/07(00:30:09), pages dumped: 1, first LSN: 177:431:1, last LSN: 177:433:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}1'}).
2007-06-07 09:15:20.03 backup Database backed up: Database: CalibaCoreData, creation date(time): 2006/11/04(17:47:08), pages dumped: 1, first LSN: 51:85:1, last LSN: 51:87:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}6'}).
2007-06-07 09:15:20.03 backup Database backed up: Database: EmailXtender, creation date(time): 2007/03/05(15:14:12), pages dumped: 1, first LSN: 14:326:1, last LSN: 14:328:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}11'}).
2007-06-07 09:15:20.03 backup Database backed up: Database: pubs, creation date(time): 2000/08/06(01:40:58), pages dumped: 1, first LSN: 12:169:1, last LSN: 12:171:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}4'}).
2007-06-07 09:15:20.03 backup Database backed up: Database: Fetch_Sales, creation date(time): 2006/11/04(17:47:39), pages dumped: 1, first LSN: 18:136:1, last LSN: 18:138:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{87A650A4-39A9-4151-B2FC-D7B4A364596B}7'}).
2007-06-07 09:30:29.15 spid78 DBCC CHECKDB (CalibaCoreData) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
2007-06-07 09:31:18.78 spid78 DBCC CHECKDB (CalibaCoreData) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
2007-06-07 09:31:34.65 spid78 DBCC CHECKDB (CalibaCoreData) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
2007-06-07 09:31:39.07 spid78 DBCC CHECKDB (CalibaCoreData) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
2007-06-07 09:37:24.74 spid78 DBCC CHECKDB (DialogCoreData) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 5 minutes 10 seconds.
2007-06-07 10:30:23.14 spid66 Database DLG_2004: IO is frozen for snapshot
2007-06-07 10:30:23.14 spid67 Database DLG_2005: IO is frozen for snapshot
2007-06-07 10:30:23.14 spid70 Database DialogCoreData: IO is frozen for snapshot
2007-06-07 10:30:23.14 spid71 Database DLG_2006: IO is frozen for snapshot
2007-06-07 10:30:24.03 spid71 Database DLG_2006: IO is thawed
2007-06-07 10:30:24.03 spid70 Database DialogCoreData: IO is thawed
2007-06-07 10:30:24.03 spid67 Database DLG_2005: IO is thawed
2007-06-07 10:30:24.03 spid66 Database DLG_2004: IO is thawed
2007-06-07 10:30:24.35 backup Database backed up: Database: DLG_2004, creation date(time): 2006/11/04(17:50:03), pages dumped: 1, first LSN: 1743:412:1, last LSN: 1743:414:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{C74B903D-F3BB-469A-AC5B-970E75689794}1'}).
2007-06-07 10:30:24.35 backup Database backed up: Database: DLG_2005, creation date(time): 2006/11/04(17:50:16), pages dumped: 1, first LSN: 6388:226:1, last LSN: 6388:228:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{C74B903D-F3BB-469A-AC5B-970E75689794}2'}).
2007-06-07 10:30:27.47 backup Database backed up: Database: DialogCoreData, creation date(time): 2007/01/28(17:37:05), pages dumped: 1, first LSN: 766089:4043:1, last LSN: 766089:4068:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{C74B903D-F3BB-469A-AC5B-970E75689794}3'}).
2007-06-07 10:30:27.50 backup Database backed up: Database: DLG_2006, creation date(time): 2007/05/03(22:17:43), pages dumped: 1, first LSN: 7350:350:1, last LSN: 7350:352:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{C74B903D-F3BB-469A-AC5B-970E75689794}4'}).
2007-06-07 12:20:01.23 backup Database backed up: Database: DialogCoreData, creation date(time): 2007/01/28(17:37:05), pages dumped: 2641771, first LSN: 766138:1194:1, last LSN: 766138:14537:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Daily_Backup\DialogCoreData\DialogCoreData.BAK'}).
2007-06-07 12:20:03.06 backup Database backed up: Database: Tempo, creation date(time): 2006/11/04(17:48:03), pages dumped: 4347, first LSN: 3966:486:1, last LSN: 3966:489:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\Daily_Backup\Tempo\Tempo.BAK'}).

SKR

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-08 : 01:14:35
Check with your backup team to see how often they do backup, you should let them do backup during off hours.
Go to Top of Page

rikleo2001
Posting Yak Master

185 Posts
Posted - 2007-06-10 : 16:48:58
They are taking incremental backup for every volume every 3-5 hours , We don't have off hours (this is 24/7) online database. International customer are connected with this database..

Any more suggestions?

Thanks in advance

SKR
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-10 : 19:07:05
That's why you see those messages in sql server log, should work out backup schedule with your backup team.
Go to Top of Page

rikleo2001
Posting Yak Master

185 Posts
Posted - 2007-06-10 : 21:25:19
Ok, I got that, so does that means it is effecting the performance?
Whole freezing and backup process is taking under a minute..I didn't understand how can SQL Server say backup of 40 GB OF DATABASE under a minute? Any reason for that?
Is that Real backup ?


SKR
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-10 : 23:13:12
It shouldn't have big performance impact. By the way, differential backup can backs up changed pages since last full backup. It's not full backup.
Go to Top of Page

rikleo2001
Posting Yak Master

185 Posts
Posted - 2007-06-11 : 00:05:51
oh.. Ok.. Thanks for your help.

SKR
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site