When I try to open the database from a workstation that has 06, I get this error.
"ACT! requires at least a serive pack 3 of SQL Server. "
I cannot copy the files off the server for some reason, it says "It is being used by another person or program." So I am going to restore right now from the original backup to a network share so I can copy it down to the workstation running 06 and attempt to do the things you listed.
I was actually just thinking of exporing the data to excel and reimporting it to a new databasae but I am afraid of data loss, so I will try your suggestion and post back to let you know how it went.
...Um, how do I write over the files that are on the server if "It is being used by another person or program."
Main Topics
Browse All Topics





by: SStrozPosted on 2007-09-22 at 13:49:55ID: 19942572
TTCLIVE,
Here's what I'd try.
Get back to a workstation that has ACT! 2006 installed. Use the actdiag tool to check, repair, and reindex the databases. Also there are "rebuild" options. I would run all of them, schema, security, oledb provider, etc. Than open the database again and backup.
Move the backups to the ACT! 2008 server and try the restore process again.
Let me know how it turns out.
Steve