x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 141 subscribers
  • Views 1295 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Michael Griggs

Removal of an archived company in database administration

Posted By

I would like to remove some of the archived data companies in SQL. When ever I upgrade or update the product, I have to update the older Archived databases. Is there a method for removing those companies and storing? I may at some point in the future need something and would import...update and use if needed. Right now they are not useful. Please let me know

  • 0

    Michael,

    There are a couple of options. You can delete them in Database Administration, in which case a backup of the database will be automatically created in the default backup location (Sage100Con\Backups\On Demand\_Deleted Companies). You will want to copy those backups to another location as they will be removed after 30 days from the default location.

    The other option is to create a new SQL instance (you can call it SAGE100ARCHIVES or something similar) and move the older archives to that instance. This way they will be separated from the companies you currently use, which will remain on your current instance. This can be done in Database Administration under the Server Management menu. You can click the ? in the upper right corner of Database Administration to get the Help window with instructions for this process.

    Greig Hollister

    Sage

*Community Hub is the new name for Sage City