 | |
DTS and JOB Scheduals
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS and JOB Scheduals -
12-01-2003
, 06:13 AM
#2
| |||
| |||
|
|
I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. |
#3
| |||
| |||
|
|
-----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . |
#4
| |||
| |||
|
|
would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . |
#5
| |||
| |||
|
|
-----Original Message----- Yes to running it in QA The syntax and description is here in BOL mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\tsq lref.chm::/ts_dbcc_00gy.htm -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:047501c3b814$3ffbf740$a001280a (AT) phx (DOT) gbl... would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . . |
#6
| |||
| |||
|
|
ran the following in querey analyiser use msbd dbcc checkdb and got the following error: Server: Msg 7995, Level 16, State 1, Line 2 Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. DBCC execution completed. If DBCC printed error messages, contact your system administrator. any idea? cheers -----Original Message----- Yes to running it in QA The syntax and description is here in BOL mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\tsq lref.chm::/ts_dbcc_00gy.htm -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:047501c3b814$3ffbf740$a001280a (AT) phx (DOT) gbl... would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . . |
#7
| |||
| |||
|
|
-----Original Message----- Have you got a backup of MSDB? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:08c601c3b81b$66bb13f0$a501280a (AT) phx (DOT) gbl... ran the following in querey analyiser use msbd dbcc checkdb and got the following error: Server: Msg 7995, Level 16, State 1, Line 2 Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. DBCC execution completed. If DBCC printed error messages, contact your system administrator. any idea? cheers -----Original Message----- Yes to running it in QA The syntax and description is here in BOL mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\tsq lref.chm::/ts_dbcc_00gy.htm -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:047501c3b814$3ffbf740$a001280a (AT) phx (DOT) gbl... would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . . . |
#8
| |||
| |||
|
|
yes we have a backup of this. what would we have to do to restore the MSDB, the backup was made by using the maintance plan, in sql server enterprise manager. -----Original Message----- Have you got a backup of MSDB? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:08c601c3b81b$66bb13f0$a501280a (AT) phx (DOT) gbl... ran the following in querey analyiser use msbd dbcc checkdb and got the following error: Server: Msg 7995, Level 16, State 1, Line 2 Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. DBCC execution completed. If DBCC printed error messages, contact your system administrator. any idea? cheers -----Original Message----- Yes to running it in QA The syntax and description is here in BOL mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\tsq lref.chm::/ts_dbcc_00gy.htm -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:047501c3b814$3ffbf740$a001280a (AT) phx (DOT) gbl... would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . . . |
#9
| |||
| |||
|
|
-----Original Message----- Stop the SQL Server Agent You can use the EM restore interface or you could also use QA RESTORE DATABASE MSDB FROM DISK = '<File Location>' WITH REPLACE You may also like to script out your Jobs before doing this as an added backup. You already have your DTS packages. If you have created any custom objects in there as well you may like to script them out as well (bcp) -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:091f01c3b81e$4732d830$a501280a (AT) phx (DOT) gbl... yes we have a backup of this. what would we have to do to restore the MSDB, the backup was made by using the maintance plan, in sql server enterprise manager. -----Original Message----- Have you got a backup of MSDB? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:08c601c3b81b$66bb13f0$a501280a (AT) phx (DOT) gbl... ran the following in querey analyiser use msbd dbcc checkdb and got the following error: Server: Msg 7995, Level 16, State 1, Line 2 Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. DBCC execution completed. If DBCC printed error messages, contact your system administrator. any idea? cheers -----Original Message----- Yes to running it in QA The syntax and description is here in BOL mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\tsq lref.chm::/ts_dbcc_00gy.htm -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:047501c3b814$3ffbf740$a001280a (AT) phx (DOT) gbl... would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . . . . |
#10
| |||
| |||
|
|
by scriptin gout the jobs does this mean all schedualed jobs would be saved also how would i do this. -----Original Message----- Stop the SQL Server Agent You can use the EM restore interface or you could also use QA RESTORE DATABASE MSDB FROM DISK = '<File Location>' WITH REPLACE You may also like to script out your Jobs before doing this as an added backup. You already have your DTS packages. If you have created any custom objects in there as well you may like to script them out as well (bcp) -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:091f01c3b81e$4732d830$a501280a (AT) phx (DOT) gbl... yes we have a backup of this. what would we have to do to restore the MSDB, the backup was made by using the maintance plan, in sql server enterprise manager. -----Original Message----- Have you got a backup of MSDB? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:08c601c3b81b$66bb13f0$a501280a (AT) phx (DOT) gbl... ran the following in querey analyiser use msbd dbcc checkdb and got the following error: Server: Msg 7995, Level 16, State 1, Line 2 Database 'msdb' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. DBCC execution completed. If DBCC printed error messages, contact your system administrator. any idea? cheers -----Original Message----- Yes to running it in QA The syntax and description is here in BOL mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\tsq lref.chm::/ts_dbcc_00gy.htm -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:047501c3b814$3ffbf740$a001280a (AT) phx (DOT) gbl... would i just run the DBCC CHECKDB command in query analyiser. also what is the correct syntax for this. -----Original Message----- I would be running DBCC CHECKDB on the msdb database. -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "adam" <adam.bird (AT) marcrist (DOT) com> wrote in message news:a44d01c3b804$7c262340$a601280a (AT) phx (DOT) gbl... I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backup the DTS jobs since we have had this problem. any help would be much appreciated. . . . . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.