I have restored the production msdb database on a test box. I can see my
entire DTS package and the scheduled jobs.
When I try to modify the job I am getting the following error.
Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSZSERVER. The job was not saved. OK Button
How to delete/update then?
SQL 2K.
Thank you,
Benjamin
Dear Benjamin,
Is the server was renamed from one name to another, if so see the
logins were in sync, another work around is
The best way to handle this problem after the rename process is to follow
these steps: 1. Rename the server back to the original name.
2. Script out all of the jobs and then delete them.
3. Rename the server to the new name.
4. Add back the jobs by running the script generated from step 2.
Or
1.Script the jobs in the server from where u backed up the msdb database.
2.Run the scripts in the new server.
for more details go through the following kb site
http://support.microsoft.com/default...b;en-us;281642
"Benjamin Nethan" wrote:
> I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
>
|||You need to update the originating_server column in sysjobs to reflect the
name of the instance you restored the database to. You can use the following
code to do that http://sqldev.net/download/sqlagent/...ent_rename.sql
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:e59AAE5pFHA.820@.TK2MSFTNGP09.phx.gbl...
>I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
Showing posts with label scheduled. Show all posts
Showing posts with label scheduled. Show all posts
Saturday, February 25, 2012
msdb Restore......
I have restored the production msdb database on a test box. I can see my
entire DTS package and the scheduled jobs.
When I try to modify the job I am getting the following error.
Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSZSERVER. The job was not saved. OK Button
How to delete/update then?
SQL 2K.
Thank you,
BenjaminDear Benjamin,
Is the server was renamed from one name to another, if so see the
logins were in sync, another work around is
The best way to handle this problem after the rename process is to follow
these steps: 1. Rename the server back to the original name.
2. Script out all of the jobs and then delete them.
3. Rename the server to the new name.
4. Add back the jobs by running the script generated from step 2.
Or
1.Script the jobs in the server from where u backed up the msdb database.
2.Run the scripts in the new server.
for more details go through the following kb site
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
"Benjamin Nethan" wrote:
> I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
>|||You need to update the originating_server column in sysjobs to reflect the
name of the instance you restored the database to. You can use the following
code to do that http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:e59AAE5pFHA.820@.TK2MSFTNGP09.phx.gbl...
>I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
entire DTS package and the scheduled jobs.
When I try to modify the job I am getting the following error.
Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSZSERVER. The job was not saved. OK Button
How to delete/update then?
SQL 2K.
Thank you,
BenjaminDear Benjamin,
Is the server was renamed from one name to another, if so see the
logins were in sync, another work around is
The best way to handle this problem after the rename process is to follow
these steps: 1. Rename the server back to the original name.
2. Script out all of the jobs and then delete them.
3. Rename the server to the new name.
4. Add back the jobs by running the script generated from step 2.
Or
1.Script the jobs in the server from where u backed up the msdb database.
2.Run the scripts in the new server.
for more details go through the following kb site
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
"Benjamin Nethan" wrote:
> I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
>|||You need to update the originating_server column in sysjobs to reflect the
name of the instance you restored the database to. You can use the following
code to do that http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:e59AAE5pFHA.820@.TK2MSFTNGP09.phx.gbl...
>I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
msdb Restore......
I have restored the production msdb database on a test box. I can see my
entire DTS package and the scheduled jobs.
When I try to modify the job I am getting the following error.
Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSZSERVER. The job was not saved. OK Button
How to delete/update then?
SQL 2K.
Thank you,
BenjaminDear Benjamin,
Is the server was renamed from one name to another, if so see the
logins were in sync, another work around is
The best way to handle this problem after the rename process is to follow
these steps: 1. Rename the server back to the original name.
2. Script out all of the jobs and then delete them.
3. Rename the server to the new name.
4. Add back the jobs by running the script generated from step 2.
Or
1.Script the jobs in the server from where u backed up the msdb database.
2.Run the scripts in the new server.
for more details go through the following kb site
http://support.microsoft.com/defaul...kb;en-us;281642
"Benjamin Nethan" wrote:
> I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or schedule
s)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
>|||You need to update the originating_server column in sysjobs to reflect the
name of the instance you restored the database to. You can use the following
code to do that http://sqldev.net/download/sqlagent...gent_rename.sql
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:e59AAE5pFHA.820@.TK2MSFTNGP09.phx.gbl...
>I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
entire DTS package and the scheduled jobs.
When I try to modify the job I am getting the following error.
Error 14274: Cannot add, update, or delete a job (or its steps or schedules)
that originated from an MSZSERVER. The job was not saved. OK Button
How to delete/update then?
SQL 2K.
Thank you,
BenjaminDear Benjamin,
Is the server was renamed from one name to another, if so see the
logins were in sync, another work around is
The best way to handle this problem after the rename process is to follow
these steps: 1. Rename the server back to the original name.
2. Script out all of the jobs and then delete them.
3. Rename the server to the new name.
4. Add back the jobs by running the script generated from step 2.
Or
1.Script the jobs in the server from where u backed up the msdb database.
2.Run the scripts in the new server.
for more details go through the following kb site
http://support.microsoft.com/defaul...kb;en-us;281642
"Benjamin Nethan" wrote:
> I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or schedule
s)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
>|||You need to update the originating_server column in sysjobs to reflect the
name of the instance you restored the database to. You can use the following
code to do that http://sqldev.net/download/sqlagent...gent_rename.sql
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:e59AAE5pFHA.820@.TK2MSFTNGP09.phx.gbl...
>I have restored the production msdb database on a test box. I can see my
> entire DTS package and the scheduled jobs.
> When I try to modify the job I am getting the following error.
> Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules)
> that originated from an MSZSERVER. The job was not saved. OK Button
> How to delete/update then?
> SQL 2K.
> Thank you,
> Benjamin
>
>
Monday, February 20, 2012
MSDB Backup Fails on SQL Server 7.0
I'm having the following problem with the backup I have running on our
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > I'm having the following problem with the backup I have running on our
> > SQL Server. I have it scheduled to run once a week and when I check
> > the event viewer I see the following:
> >
> > SQL Server Scheduled Job 'msdb backup'
> > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > 1).
> >
> > Event ID: 208
> >
> > The script I'm using for my backup is as follows:
> >
> > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > DECLARE @.i INT
> > select @.i = position from msdb..backupset where database_name='msdb'and
> > type!='F' and backup_set_id=(select max(backup_set_id) from
> > msdb..backupset where database_name='msdb')
> > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> >|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
> > Can you post the Error / message from the step 1: of this job. That
> > probability gives more info. regarding the failure.
> >
> >
> >
> > -Saravanan
> >
> >
> >
> > "Creative" <GraberJ@.gmail.com> wrote in message
> > news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > > I'm having the following problem with the backup I have running on our
> > > SQL Server. I have it scheduled to run once a week and when I check
> > > the event viewer I see the following:
> > >
> > > SQL Server Scheduled Job 'msdb backup'
> > > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > > 1).
> > >
> > > Event ID: 208
> > >
> > > The script I'm using for my backup is as follows:
> > >
> > > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > > DECLARE @.i INT
> > > select @.i = position from msdb..backupset where database_name='msdb'and
> > > type!='F' and backup_set_id=(select max(backup_set_id) from
> > > msdb..backupset where database_name='msdb')
> > > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> > >
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > I'm having the following problem with the backup I have running on our
> > SQL Server. I have it scheduled to run once a week and when I check
> > the event viewer I see the following:
> >
> > SQL Server Scheduled Job 'msdb backup'
> > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > 1).
> >
> > Event ID: 208
> >
> > The script I'm using for my backup is as follows:
> >
> > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > DECLARE @.i INT
> > select @.i = position from msdb..backupset where database_name='msdb'and
> > type!='F' and backup_set_id=(select max(backup_set_id) from
> > msdb..backupset where database_name='msdb')
> > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> >|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
> > Can you post the Error / message from the step 1: of this job. That
> > probability gives more info. regarding the failure.
> >
> >
> >
> > -Saravanan
> >
> >
> >
> > "Creative" <GraberJ@.gmail.com> wrote in message
> > news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> > > I'm having the following problem with the backup I have running on our
> > > SQL Server. I have it scheduled to run once a week and when I check
> > > the event viewer I see the following:
> > >
> > > SQL Server Scheduled Job 'msdb backup'
> > > (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> > > 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> > > by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> > > 1).
> > >
> > > Event ID: 208
> > >
> > > The script I'm using for my backup is as follows:
> > >
> > > BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> > > NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> > > DECLARE @.i INT
> > > select @.i = position from msdb..backupset where database_name='msdb'and
> > > type!='F' and backup_set_id=(select max(backup_set_id) from
> > > msdb..backupset where database_name='msdb')
> > > RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
> > >
MSDB Backup Fails on SQL Server 7.0
I'm having the following problem with the backup I have running on our
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:[vbcol=seagreen]
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:[vbcol=seagreen]
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
SQL Server. I have it scheduled to run once a week and when I check
the event viewer I see the following:
SQL Server Scheduled Job 'msdb backup'
(0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
1).
Event ID: 208
The script I'm using for my backup is as follows:
BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
DECLARE @.i INT
select @.i = position from msdb..backupset where database_name='msdb'and
type!='F' and backup_set_id=(select max(backup_set_id) from
msdb..backupset where database_name='msdb')
RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.iCan you post the Error / message from the step 1: of this job. That
probability gives more info. regarding the failure.
-Saravanan
"Creative" <GraberJ@.gmail.com> wrote in message
news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...
> I'm having the following problem with the backup I have running on our
> SQL Server. I have it scheduled to run once a week and when I check
> the event viewer I see the following:
> SQL Server Scheduled Job 'msdb backup'
> (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on:
> 8/13/2006 12:00:00 AM - Message: The job failed. The Job was invoked
> by Schedule 4209 (Schedule 1). The last step to run was step 1 (Step
> 1).
> Event ID: 208
> The script I'm using for my backup is as follows:
> BACKUP DATABASE [msdb] TO [H:\SQLServerBackUpNBR] WITH NOINIT ,
> NOUNLOAD , NAME = N'msdb backup', SKIP , STATS = 10, NOFORMAT
> DECLARE @.i INT
> select @.i = position from msdb..backupset where database_name='msdb'and
> type!='F' and backup_set_id=(select max(backup_set_id) from
> msdb..backupset where database_name='msdb')
> RESTORE VERIFYONLY FROM [H:\SQLServerBackUpNBR] WITH FILE = @.i
>|||Are you referring to within SQL Server? Sorry I'm a little new at
troubleshooting SQL Server and I'm not sure where the error message is
you're looking for. All I can find is the one in the Event Viewer that
I posted below and the other is when I view Job History I see "The job
failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
step to run was step 1 (Step 1)." which tells me nothing.
If this isn't what you wanted please tell me where to find what you are
referring to.
Thanks
Saravanan Palanivelu wrote:[vbcol=seagreen]
> Can you post the Error / message from the step 1: of this job. That
> probability gives more info. regarding the failure.
>
> -Saravanan
>
> "Creative" <GraberJ@.gmail.com> wrote in message
> news:1155651035.260790.231840@.i42g2000cwa.googlegroups.com...|||Ok here is the error message from the Job History File. Any
suggestions would be appreciated.
No entry in sysdevices for backup device 'H:\SQLServerBackUpNBR'.
Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206)
Backup or restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013) Associated statement is not prepared [SQLSTATE HY007]
(Error 0) No entry in sysdevices for backup device
'H:\SQLServerBackUpNBR'. Update sysdevices and rerun statement.
[SQLSTATE 42000] (Error 3206) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Creative wrote:[vbcol=seagreen]
> Are you referring to within SQL Server? Sorry I'm a little new at
> troubleshooting SQL Server and I'm not sure where the error message is
> you're looking for. All I can find is the one in the Event Viewer that
> I posted below and the other is when I view Job History I see "The job
> failed. The Job was invoked by Schedule 4209 (Schedule 1). The last
> step to run was step 1 (Step 1)." which tells me nothing.
> If this isn't what you wanted please tell me where to find what you are
> referring to.
> Thanks
>
> Saravanan Palanivelu wrote:
Subscribe to:
Posts (Atom)