Error SQL procedure

[JohnJohn]

Hi @ll,

Today we had a problem with the database because that was full. I followed this procedure to clean the logs:

http://www.symantec.com/business/support/index?page=content&id=TECH201551&profileURL=https%3A%2F%2Fs...

My BDD decreased from 4 GB to 60 MB

Now I can create job but it does not execute. in the event viewer I get errors:

Could not find stored procedure 'DBO.SAVEJOBHISTORY'

In fact, when I look in the SQL database I do not have this procedure.

Is it possible to rebuild database for recreate the original tables and keep my job history?

[samueljn]

It is possible if you have a backup of the old database. You can import the old database using BEUTILITY.

I guess you were using SQL 2005 which has the limitation of 4GB. You can create an instance with SQL 2008 express which supports upto 10GB.

[JohnJohn]

Thanks samueljn,

I get use BEutility for restoring old database. It's a good idea to switch in sql express 2008...