09-09-2011 09:07 PM
09-10-2011 01:19 PM
The error is occurring due to a bug in Microsoft SQL Server 2008 (R2). Microsoft has claimed to have fixed this in SP1 of SQL 2008 but unfortunately we were not able to include this as part of the release because it wasn't formally released until late July when product development for ACT! had completed. The fix in SP1 would prevent this problem from occurring but it isn't corrective once a database is in this state. However, we do have a solution for you.
Go to C:\Program Files\ACT\Act for Windows
In the folder there are two files that will correct your problem
One is for SQL Express, the other is for all other versions of SQL Server. I'm assuming that you just installed ACT! and let the installer do it's thing and you are not an admin supporting a 30+ installation and installed SQL Server Standard. That being the case you will use the Express_BackupFix.bat
After you locate the bat file for your version, perform these steps:
To prevent the problem from occurring again you can install SP1 of SQL 2008 through automatic windows updates or you can get a copy here It’s available at: http://www.microsoft.com/download/en/details.aspx?id=26727
Sorry for the inconvenience.
09-12-2011 11:54 AM