relocating the main ACT database

hi weve upgraded our 2003 and network to 2008 and i need to relocate the main act database to a new server and have that server as the main sync server, how do i go about doing it?

not via remote database im guessing

Thanks
LVL 1
awilderbeastAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
First, I assume you have ACT! 2010? Otherwise, it may not work on Win 2008

Second, what method of sync? Network or Internet service (only with Premium versions of ACT!) or Application sync (needs ACT! to be open and logged into database).
0
awilderbeastAuthor Commented:
no we have act 2009 premium... :S you know if there is issues with that?

would sync across vpn, so network sync and all 2009 premium versions

cheers
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
ACT! 2009 wasn't tested on Windows 2008... and I haven't heard from users who have tried, so not 100% sure

To move the database, follow this KB: http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=19818
Especially see the item near the top about sync

Also make sure ALL users and sync server are 11.1 +HF3 as per http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=25310
There were a number of fixes for sync in the patches

To set up sync, see these:
http://blog.glcomputing.com.au/2009/02/sharing-act-network-or-sync.html
http://blog.glcomputing.com.au/2009/01/sharing-act-network-or-sync-part-1.html
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

awilderbeastAuthor Commented:
hi just started with the backup today

i get the below error, filename too big

i went to the attachments folder, unticked read only so i could delete that file

yet when i go to delete it i cant :S

delete key does nothing, delte isnt in the right click menu, how can i remove this file?

Thanks
error.jpg
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Are you doing it while on the server and logged in as an Admin?
0
awilderbeastAuthor Commented:
yeah where doing it on the server and logged in as admin

been trying to back it up all weeekend

it keeps getting to a file then breaking then we delete that file and start it again and it breaks again and again...

i think its something to do with the problem in another question, with the huge file names and 33,000 attachments for 11,000 contacts lots of invlaid files names


does act by default add random characters to duplicate file names or is this a script that our olf it support company has set up, i think they did set something up for duplicates, and if its this it was coded very badly :|
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The adding of the GUID to the file names when edited in a sync environment was a bug now fixed.

The file name, in this case, has become to long for Windows and the ZIP program to handle... the best option is to log in as a Windows Admin - in W2008, you might need to also start Explorer by right-clicking on the Explorer icon and selecting run as Admin.

Then you should be able to delete the file and try it again.

In the mean time, try the Batch file backup as I mention here:
http://www.experts-exchange.com/articles/Database/Contact_Management/ACT/Automating-backups-for-ACT-by-Sage.html

Note this:
It's also useful to occasionally check that the "Backup" folder under  the database supplemental files folder is empty. This is where ACT!  places temp files during the backup process. If the backup fails, they  remain there and will be included in any subsequent backups. You can  delete any files in this folder unless a backup is currently in  operation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I have no idea where that URL link at the bottom cam from....
0
awilderbeastAuthor Commented:
so those filenames where sage' idea? terrible!

so i can use the below and that will backup the entire database for me?

i don thave supplemental files under back up
i only have back up

which has 3 BAK files in it

  REM - Change these SET Parameters as appropriate for your system
  SET ACTSourceFolder="C:\Act\Database"
  SET ACTDestinationFolder="D:\Backups\Act\Database"
  SET XcopyOptions=/M /E /C /H /O /Y /I
  REM
  REM - Stop ACT SQL Service
  NET STOP SQLAGENT$ACT7
  NET STOP MSSQL$ACT7
  REM
  REM - Perform copy
  XCOPY %ACTSourceFolder% %ACTDestinationFolder% %XcopyOptions%
  REM
  REM - Restart ACT SQL Service
  NET START MSSQL$ACT7
  NET START SQLAGENT$ACT7
  END

Open in new window

0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Under Database folder - "CW60-database files" - you have a number of folders including Attachments (where this file is) and Backup

You can (and should) delete anything in the Backup folder.... and this file with the long name

The Backup folder is used for Temp files when creating the backup... if the backup fails (as yours has), they sometimes remain there and get included in the next backup making the file size much larger
0
awilderbeastAuthor Commented:
the file names that fail are all attachments, i think its failign on all the invalid file names

if i use that script your provided will tha tignore the invalid names?
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Try and XCOPY one of the files with a long name (one that failed)... see if it works.

See http://en.wikipedia.org/wiki/Long_filename

You could also do a Backup in ACT! and tell it not to include Attachments, then copy those later - at least this way, the database will be backed up properly

You should also stop any anti virus and see if that helps as per:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14233
0
awilderbeastAuthor Commented:
its not getting to a invalid attachment anymore

it keeps coming back

doesnt even say where the file is located

i cleared that backup folder too it only had three files in it, i deleted them though
error.jpg
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Can you do a search for that file?
0
awilderbeastAuthor Commented:
yeah did do, searched the entire c drive, doesnt exist :|
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
And you're doing this on the server?

Have you unchecked to include attachments when running the backup?
0
awilderbeastAuthor Commented:
yeah unchecked works instantly

but my bosses say im not allowed to do it, they want the attachments

i just ran it agian with yet another... new error

an I/O exception occured while copying the data from the item to its detination.
Type: exceed.filesystem.diskfile
fullname server01\cw60-database files\backup\server01_cw60_d20100413t111658.bak
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Have you tried the backup script above? At least then, you'll have a copy.

You have that issue with the GUIDs bug from a previous build.... I know some ways to fix it, but they wouldn't be free.

You might contact Sage support and see if they have a recommended fix to clean up attachments caused by that error

Let me know what they say
0
awilderbeastAuthor Commented:
sage tech cant assisnt us as we had a contract with one of their business partners and we would need to take out another yearly contracts

will your fixes defintley sort out the attachment problem and allow us to backup and move the database to the new server?

how much would your services cost?

thanks
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The XCOPY should allow you to move the database... when on the new server, delete the PAD file. Then open ACT! - File | Open | Change File type to ADB - open the database.

When you move it, make sure the new path is short - create a folder off the root of a drive (eg c:\actdb) and put the database there

If that works, will be easier for you to send me a copy to test... if not, I'd have to write a program you can install and run locally.
0
awilderbeastAuthor Commented:
ok ran the batch file and got output as below

copy failed

C:\Documents and Settings\Administrator\Desktop>SET ACTSourceFolder="F:\ACT!"

C:\Documents and Settings\Administrator\Desktop>SET ACTDestinationFolder="F:\ACT
!\BACKUP"

C:\Documents and Settings\Administrator\Desktop>SET XcopyOptions=/M /E /C /H /O
/Y /I

C:\Documents and Settings\Administrator\Desktop>REM

C:\Documents and Settings\Administrator\Desktop>REM - Stop ACT SQL Service

C:\Documents and Settings\Administrator\Desktop>NET STOP SQLAGENT$ACT7
System error 1060 has occurred.

The specified service does not exist as an installed service.


C:\Documents and Settings\Administrator\Desktop>NET STOP MSSQL$ACT7
The SQL Server (ACT7) service is stopping.
The SQL Server (ACT7) service was stopped successfully.


C:\Documents and Settings\Administrator\Desktop>REM

C:\Documents and Settings\Administrator\Desktop>REM - Perform copy

C:\Documents and Settings\Administrator\Desktop>XCOPY "F:\ACT!" "F:\ACT!\BACKUP"
 /M /E /C /H /O /Y /I
Cannot perform a cyclic copy
0 File(s) copied

C:\Documents and Settings\Administrator\Desktop>REM

C:\Documents and Settings\Administrator\Desktop>REM - Restart ACT SQL Service

C:\Documents and Settings\Administrator\Desktop>NET START MSSQL$ACT7
The SQL Server (ACT7) service is starting.

Open in new window

0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
This error is nothing to worry about, not all systems need this service

System error 1060 has occurred.
The specified service does not exist as an installed service.

This error is because XCOPY is copying all sub-folders and you're trying to copy to a subfolder. Copy to F:\ACT2

Cannot perform a cyclic copy
BTW: I recommend NOT using special characters like "!" in folder names.
0
awilderbeastAuthor Commented:
ok it ran this time, but it only copied two files

the CW60.ADF and CW60ALF

it created all the other folders but it didnt copy any data from them

i have CW60-database files folder but no files in it

can i just copy and paste those files?
0
awilderbeastAuthor Commented:
i overlooked the detach datbase from sql then copy note at the bottom, that has worked, i now have act installed on the new server

but still have a few problems, ill open another question for those

THanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ACT

From novice to tech pro — start learning today.