Video Screencast Help

Error SQL procedure

Created: 04 Oct 2013 | 2 comments

Hi @ll,

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

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?

Operating Systems:

Comments 2 CommentsJump to latest comment

samueljn's picture

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's picture

Thanks samueljn,

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