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.
| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2001-07-23 : 04:46:48
|
| SQL 7.0 SP1 - NT 4 EE SP6a - ClusterI need to understand why I receive two differentes informations thru NT Event logwhen the scheduled jobs finish the work.First NT Event Log:Date: 23/07/2001 Event ID: 17055Time: 07:00:04 Source: MSSQLServer$SRVSQLUSER: LUGANO/SQL-Service Type: InformationComputer: SRV0001B Category (6)The description for Event ID ( 17055 ) in Source ( MSSQLServer$SRVSQL ) could not be found. It contains the following insertion string(s): 18265, Log backed up with following information: Database: HRArchive, creation date and time: 1999/11/08(09:29:38), first LSN: 5:10942:1, last LSN: 5:12767:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'J:\MSSQL7\BACKUP\HRArchive\HRArchive_tlog_200107230700.TRN'}).Second NT Event Log:Date: 23/07/2001 Event ID: 17055Time: 10:00:03 Source: MSSQLServer$SRVSQLUSER: SQL-Service Type: InformationComputer: SRV0001B Category Backup18265 :Log backed up with following information: Database: AJL_Contabilita_PROD01, creation date and time: 2001/01/09(17:09:52), first LSN: 349:3195:1,last LSN:349:3332:1, striped: 0, number of dump devices: 1, device information:(FILE=1, TYPE=DISK: {'J:\MSSQL7\BACKUP\AJL_Contabilita_PROD01\AJL_Contabilita_PROD01_tlog_200107231000.TRN'}). Boths jobs succeeds, but I need to know why in one case I have differentes informationsabout the category and about the User.I also need to understand why the message is different in the first part (The description for Event ID ( 17055 ) in Source ( MSSQLServer$SRVSQL ) could not be found. It contains the following insertion string(s): 18265, Log backed up...) andwhat does it mean.Boths Jobs have been created thru Maintenance Plan by the same user.Thank you - Franco |
|
|
|
|
|
|
|
SQL Backup on Cluster