截屏视频帮助

Error SQL procedure

创建时间: 04 10 月 2013 | 2 条评论

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?

评论 条评论跳转至最新评论

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