Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL6.5 can't schedule recurring backup

Status
Not open for further replies.

soozle

IS-IT--Management
Jun 5, 2001
69
I've just done a clean install of SQL6.5 (and updgraded to 6.5a), restored our databases (from a different server) and I'm trying to setup a daily backup task.

I can do an immediate backup but on filling in the 'schedule backup' dialog then pressing OK. I get the error message
'Error 2812:[SQL Server] Stored procedure 'msdb..sp_helptask' not found.'

I'm checking out the help files but though it might be faster to ask the expertshere.
TIA
Soozle
 
BOL suggested running INSTMSTR.SQL but I can't find that on the server and weirder I can't login to the server using ISQL_w or Enterprise manager at the server but both apps can login from my workstation.
I've installed a few times and never had this problem...
soozle
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top