x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 133 subscribers
  • Views 567 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
769
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
854
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
878
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
LeShel Rich

Sage 300 crashes on company when sql database was restored from production to test

SOLVED
Posted By

We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error.  Other companies work so it has to be the database but it is the same as in production.  I change the database setup to go straight to the sql server rather than the odbc connection, but it does the same thing.  Any ideas?

Parents
  • 0

    Have you tried simply dumping and loading the data back in after performing the SQL restore?  I find this helps clean up any bizzare locks or strange states the backup may have been in when it was taken.  Keep using the ODBC connection and just dump your test database out and then load the DB dump straight back in.  Let us know how that goes.

Reply
  • 0

    Have you tried simply dumping and loading the data back in after performing the SQL restore?  I find this helps clean up any bizzare locks or strange states the backup may have been in when it was taken.  Keep using the ODBC connection and just dump your test database out and then load the DB dump straight back in.  Let us know how that goes.

Children

*Community Hub is the new name for Sage City