SQL Server Performance Forum – Threads Archive

Error 913 in maintenance plan

I am using sql server 7.0 sp3. i got this error in maintenance plan. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 913: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find database ID 38. Database may not be activated yet or may be in transition.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
I found this artical on same Error 913,Which say that "You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs" http://support.microsoft.com/default.aspx/kb/834688 But problem is i am not running any query ,This error is coming in maintenance plan which take backup. Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–

Check: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_2d4j.asp
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

execute this query under master database: – select * from sysdatabases where dbid=38 find the name/ status of database from output and re-check the maintenance plan against that database. Deepak Kumar –An eye for an eye and everyone shall be blind

After executing above query i got this output:
Database Name:ABC
Status :4194312
Status2 :1090519040 This database is online and i am able to query. My problem is why this error is coming in maintenance plan where as my database is online and running fine for other task.
Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–

I suggest you to apply SP4 to SQL server and with this the error might have fixed.
In SQL 2K it is fixed with SP3a. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>