10-10-2016 04:51 AM
Hello Everyone! This is my first post, so please forgive me if I am doing something wrong.
I am running: Act! Pro Version 18.104.22.168, Hot Fix 5
When trying to backup my database, I get this message:
Backup destination "\\server" supports a FILESTREAM filegroup. This filegroup cannot be used as backup destination. Rerun the BACKUP statement with a valid backup destination.
BACKUP DATABASE is terminating abnormally.
PRC_MAINT_BACKUPDB: ERROR EXECUTING DATABASE BACKUP STATEMENT
I have tried to backup to various destinations, but get the same message. I tried
C:\Users\"username"\Documents\ACT\ACT Data\Backup\Act! SERVERDB.zip
G:\Backup\Act! SERVERDB.zip (USB Drive)
M:\Backup\Act! SERVERDB.zip (NAS Server - Network)
Any help in solving this problem would be appreciated!
Thanks in advance!
10-10-2016 06:27 AM
Just to confirm, are you experiencing this error when using the File > Back Up feature in Act?
It appears that the issue was resolved in SQL Server 2012 RTM.
You could try backing up though ActDiag:
This method will not include your attachments and templates .etc. Please copy the Database Files folder separately to ensure you have a complete backup.
If this method also runs into the same error, then your options would be to upgrade to SQL Server 2012 (this must be done as a manual upgrade from 2008), or upgrade your version of Act to v17 or later which includes SQL Server 2014 (SQL Server 2008 must be removed before upgrading).
10-10-2016 06:38 AM
Thank you very much for your reply!
I tried to backup from actdiag without any luck Although I get a different message now: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The backup or restore was aborted."
I guess I will have to go ahead and upgrade the SQL Server.
10-11-2016 09:11 AM
I just created a new database and backed it up without any problems.
I can also backup the Act2010Demo database
If it’s the SQL 2008 bug, wouldn’t it behave the same with all databases?
I ran check and repair, whick did not help...
Thanks in advance!
10-12-2016 03:25 AM
10-16-2016 07:41 AM
Sorry for the late reply, I was traveling.
Both old and new deatabasr are in the same location. The old one wont backup and the new one has no problem.
10-17-2016 02:20 AM