Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Create New Aeros Database from Master Database

  • Login into SQL Studio and Connect to Agrisoft-TB2 instance.
  • Start a New Query
  • Backup Master Database Desired. (This includes Ext, Audit and Attachment) - ie: ERP_Master_323
    • exec sp_backupdatabase 'ERP_Master_323'
    • exec sp_backupdatabase 'ERP_Master_323_Attachment'
    • exec sp_backupdatabase 'ERP_Master_323_Audit'
    • exec sp_backupdatabase 'ERP_Master_323_Ext'
  • Backup files are created.
    • ERP_Master_323_Backup_201407171200.bak
    • ERP_Master_323_Attachment_Backup_201407171200.bak
    • ERP_Master_323_Audit_Backup_201407171200.bak
    • ERP_Master_323_Ext_Backup_201407171200.bak
  • Login into SQL Studio to desired New Database location. ie: Agrisoft-TB2\SUPPORT.
  • Start a New Query
  • Restore Master Database to desired New Database. (This includes Ext, Audit and Attachment)
    • exec sp_restoredatabase 'ERP_xxxxxxxx_323', 'ERP_Master_323_Backup_201407171200.bak'
    • exec sp_restoredatabase 'ERP_xxxxxxxx_323_Attachment', 'ERP_Master_323_Attachment_Backup_201407171200.bak'
    • exec sp_restoredatabase 'ERP_xxxxxxxx_323Audit', 'ERP_Master_323_Audit_Backup_201407171200.bak'
    • exec sp_restoredatabase 'ERP_xxxxxxxx_323Ext', 'ERP_Master_323_Ext_Backup_201407171200.bak'
  • Select new datbase in SQL. Start a New Query. Run exec spSetSynonyms under the new datbase connection.
  •  
  • No labels