Community
Showing results for 
Search instead for 
Do you mean 
Reply

Backup cannot find stored procedure...

New Member
Posts: 4
Country: USA

Backup cannot find stored procedure...

Error message up backup regardless of location..

"The following erroe occured. The backup was cancelled....'Could not find stored procedure'master.dbo.PRC_MAINT_BACKUPDB'

 

Act!2012 Pro

Windows 7

 

Trying to backup in order to relcate dabase to a new computer.

 

Thanks in advance.

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Backup cannot find stored procedure...

Hello Dewey7,

Welcome to the ACT! Community!

 

This error may indicate an issue with the installation of the Sage ACT! program. You can verify this by opening the Demo database and attempting to create a backup.  If it also fails, an uninstall/reinstall of Sage ACT! may resolve the error. 

 

Noting that you are moving to a new computer, if Sage ACT! will no longer be used on the original computer, you can use the instructions in the following article to move the database to the new computer: KB Article 23392

Greg Martin
Sage
New Member
Posts: 4
Country: USA

Re: Backup cannot find stored procedure...

Unable to find demo file.  Empty folder.

Unable to just relcote database to the new compter  Went to run, actdiag.....error message 'master_PRC_MAINT_DATABASE...

 

If I uninstall and reinstall Act!, will I not delete my hard earned database files?

 

Please advise and thanks

 

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Backup cannot find stored procedure...

Uninstall/reinstall won't affect the database, but another option for moving the database is to stop the 'SQL Server (ACT7)' service. That will take the lock off of the files so they can be moved. To do this:
- click Windows Start button
- enter 'Services.msc' into search field > press ENTER key
- on Services window, locate 'SQL Server (ACT7)'
- right-click service and select Stop
You will be able to copy the files.
Greg Martin
Sage
New Member
Posts: 4
Country: USA

RESOLUTION Re: Backup cannot find stored procedure...

Thanks for the help.  Uninstall and reinstall did the trick. 

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: RESOLUTION Re: Backup cannot find stored procedure...

Glad to hear it is resolved! Thanks for posting the update.
Greg Martin
Sage