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:

http://www.symantec.com/business/support/index?page=content&id=TECH201551&profileURL=https%3A%2F%2Fsymaccount-profile.symantec.com%2FSSO%2Findex.jsp%3FssoID%3D1380891838890J961jv2jbN18Fmpi0w55SX3K02s1T92AIT0wL

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...