ERROR: Subreport: entries

Showing posts with label entries. Show all posts

Wednesday, March 21, 2012

errors whan running backup plan

My event log has the following entries every day ( because the plan runs every
day)
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels Backup
Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by Schedule
20 (Schedule 1). The last step to run was step 1 (Step 1).
That error message follows four other entries like this.
Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump devices:
1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
I seem to have all the backups in the folder that there should be, but then what
is happening with the first error message?
I also can manually make a backup without any error messages appearing so
something is wrong with my plan but what? it doesn't look that complicated to
set up.Do you have any other steps on this maintenance plan such as an integrity
check?
Jim
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
> Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Do you get any better errormessages if you specify a report file for the
plan and check that report file?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
> Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Ahh that was helpful.
here is what I get:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
...
So I removed the system databases leaving only my database from the backup
and it went fine. do I need to save the system databases differently? or at
all?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Do you get any better errormessages if you specify a report file for the
> plan and check that report file?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "mmac" <mmac@.junkmail.bin> wrote in message
> news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > My event log has the following entries every day ( because the plan runs
> every
> > day)
> >
> > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
'Michaels
> Backup
> > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
on:
> > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> Schedule
> > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> >
> > That error message follows four other entries like this.
> >
> > Database backed up: Database: model, creation date(time):
> 2000/08/06(01:40:52),
> > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> devices:
> > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
> SQL
> > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> >
> > I seem to have all the backups in the folder that there should be, but
> then what
> > is happening with the first error message?
> > I also can manually make a backup without any error messages appearing
so
> > something is wrong with my plan but what? it doesn't look that
complicated
> to
> > set up.
> >
> >
>|||> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
Yes, create a different maint pan for master, model and msdb and do backup
once a day... :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <no@.thanks.com> wrote in message
news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> Ahh that was helpful.
> here is what I get:
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
> 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs
to
> be in single user mode.
> ...
> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > Do you get any better errormessages if you specify a report file for the
> > plan and check that report file?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "mmac" <mmac@.junkmail.bin> wrote in message
> > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > My event log has the following entries every day ( because the plan
runs
> > every
> > > day)
> > >
> > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> 'Michaels
> > Backup
> > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
> on:
> > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> > Schedule
> > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > >
> > > That error message follows four other entries like this.
> > >
> > > Database backed up: Database: model, creation date(time):
> > 2000/08/06(01:40:52),
> > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> > devices:
> > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
Files\Microsoft
> > SQL
> > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > >
> > > I seem to have all the backups in the folder that there should be, but
> > then what
> > > is happening with the first error message?
> > > I also can manually make a backup without any error messages appearing
> so
> > > something is wrong with my plan but what? it doesn't look that
> complicated
> > to
> > > set up.
> > >
> > >
> >
> >
>|||and they will backup in "single user mode"?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> > So I removed the system databases leaving only my database from the
> backup
> > and it went fine. do I need to save the system databases differently? or
> at
> > all?
> Yes, create a different maint pan for master, model and msdb and do backup
> once a day... :-)
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "mmac" <no@.thanks.com> wrote in message
> news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > Ahh that was helpful.
> > here is what I get:
> >
> >
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> > 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> > Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
> > 'MASTER'.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> > [1] Database master: Check Data and Index Linkage...
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Repair statement not processed. Database needs
> to
> > be in single user mode.
> > ...
> > So I removed the system databases leaving only my database from the
> backup
> > and it went fine. do I need to save the system databases differently? or
> at
> > all?
> >
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > Do you get any better errormessages if you specify a report file for the
> > > plan and check that report file?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at:
> > >
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > >
> > >
> > > "mmac" <mmac@.junkmail.bin> wrote in message
> > > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > > My event log has the following entries every day ( because the plan
> runs
> > > every
> > > > day)
> > > >
> > > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > 'Michaels
> > > Backup
> > > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
> > on:
> > > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> > > Schedule
> > > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > > >
> > > > That error message follows four other entries like this.
> > > >
> > > > Database backed up: Database: model, creation date(time):
> > > 2000/08/06(01:40:52),
> > > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> > > devices:
> > > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
> Files\Microsoft
> > > SQL
> > > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > > >
> > > > I seem to have all the backups in the folder that there should be, but
> > > then what
> > > > is happening with the first error message?
> > > > I also can manually make a backup without any error messages appearing
> > so
> > > > something is wrong with my plan but what? it doesn't look that
> > complicated
> > > to
> > > > set up.
> > > >
> > > >
> > >
> > >
> >
> >
>|||There's no need to set the single user mode unless you check the dreaded
"Attempt to repair minor problems" under the integrity check part. I do not
recommend using this option at all. If I have a problem with a corrupt
database, I want to know that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:uy7MGro$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> and they will backup in "single user mode"?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> > > So I removed the system databases leaving only my database from the
> > backup
> > > and it went fine. do I need to save the system databases differently?
or
> > at
> > > all?
> >
> > Yes, create a different maint pan for master, model and msdb and do
backup
> > once a day... :-)
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "mmac" <no@.thanks.com> wrote in message
> > news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > > Ahh that was helpful.
> > > here is what I get:
> > >
> > >
> > > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server
> > > 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> > > Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30
PM
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
database
> > > 'MASTER'.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
failed.
> > > [1] Database master: Check Data and Index Linkage...
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Repair statement not processed. Database
needs
> > to
> > > be in single user mode.
> > > ...
> > > So I removed the system databases leaving only my database from the
> > backup
> > > and it went fine. do I need to save the system databases differently?
or
> > at
> > > all?
> > >
> > >
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in
> > > message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > > Do you get any better errormessages if you specify a report file for
the
> > > > plan and check that report file?
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at:
> > > >
> > >
> >
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > > >
> > > >
> > > > "mmac" <mmac@.junkmail.bin> wrote in message
> > > > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > > > My event log has the following entries every day ( because the
plan
> > runs
> > > > every
> > > > > day)
> > > > >
> > > > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > > 'Michaels
> > > > Backup
> > > > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed -
Invoked
> > > on:
> > > > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked
by
> > > > Schedule
> > > > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > > > >
> > > > > That error message follows four other entries like this.
> > > > >
> > > > > Database backed up: Database: model, creation date(time):
> > > > 2000/08/06(01:40:52),
> > > > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of
dump
> > > > devices:
> > > > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
> > Files\Microsoft
> > > > SQL
> > > > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > > > >
> > > > > I seem to have all the backups in the folder that there should be,
but
> > > > then what
> > > > > is happening with the first error message?
> > > > > I also can manually make a backup without any error messages
appearing
> > > so
> > > > > something is wrong with my plan but what? it doesn't look that
> > > complicated
> > > > to
> > > > > set up.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

errors whan running backup plan

Wednesday, March 7, 2012

Errors

Folks,
This might not be SQL Server related, but nevertheless, it brought our production sql server to a halt. Does anyone know what these entries mean?
System log:-
Event Type:Error
Event Source:Perflib
Event Category:None
Event ID:1015
Date:7/20/2004
Time:4:24:56 AM
User:N/A
Computer:TOROONDC975
Description:
The timeout waiting for the performance data collection function
"PerfOS" in the "C:\WINNT\system32\perfos.dll" Library to finish
has expired. There may be a problem with this extensible counter
or the service it is collecting data from or the system may have
been very busy when this call was attempted.
Application log:-
Event Type:Information
Event Source:Application Popup
Event Category:None
Event ID:26
Date:7/20/2004
Time:6:45:21 PM
User:N/A
Computer:TOROONDC975
Description:
Application popup: cmd.exe - Application Error : The application
failed to initialize properly (0xc0000142). Click on OK to terminate
the application.
Any guidance is much appreciated.
Karthik.
PS: We are running
SQL 2K Enterprise Edition SP3
Windows 2K Advanced Server
What do the sql error log say? That error message doenst seem like an event
that could bring a machine down.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Well, it occured on a server that happened to be our production SQL Server. Not really a SQL Server error. Anyways, the reason this brought our server down was because there was about 150 CMD.EXE running when we looked at the unresponsive server in the mo
rning. And we found the errors I have attached in the event viewer.
Thanks.
"Vikram Jayaram [MS]" wrote:

> What do the sql error log say? That error message doenst seem like an event
> that could bring a machine down.
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
>

Errors

Folks,
This might not be SQL Server related, but nevertheless, it brought our produ
ction sql server to a halt. Does anyone know what these entries mean?
System log:-
Event Type: Error
Event Source: Perflib
Event Category: None
Event ID: 1015
Date: 7/20/2004
Time: 4:24:56 AM
User: N/A
Computer: TOROONDC975
Description:
The timeout waiting for the performance data collection function
"PerfOS" in the "C:\WINNT\system32\perfos.dll" Library to finish
has expired. There may be a problem with this extensible counter
or the service it is collecting data from or the system may have
been very busy when this call was attempted.
Application log:-
Event Type: Information
Event Source: Application Popup
Event Category: None
Event ID: 26
Date: 7/20/2004
Time: 6:45:21 PM
User: N/A
Computer: TOROONDC975
Description:
Application popup: cmd.exe - Application Error : The application
failed to initialize properly (0xc0000142). Click on OK to terminate
the application.
Any guidance is much appreciated.
Karthik.
PS: We are running
SQL 2K Enterprise Edition SP3
Windows 2K Advanced ServerWhat do the sql error log say? That error message doenst seem like an event
that could bring a machine down.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Well, it occured on a server that happened to be our production SQL Server.
Not really a SQL Server error. Anyways, the reason this brought our server d
own was because there was about 150 CMD.EXE running when we looked at the un
responsive server in the mo
rning. And we found the errors I have attached in the event viewer.
Thanks.
"Vikram Jayaram [MS]" wrote:

> What do the sql error log say? That error message doenst seem like an even
t
> that could bring a machine down.
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
>

Wednesday, March 21, 2012

errors whan running backup plan

errors whan running backup plan

Wednesday, March 7, 2012

Errors

Errors

ERROR: Subreport

Blog Archive

About Me