RSS

Monthly Archives: March 2016

How to: Export/Import a Model Store

DAX Beginners

When I wrote about Deploying customizations across Microsoft Dynamics AX environments I said that Microsoft recommends you to use export and then install the Model Store when you deploy major changes to a production environment. You can export and import a model store as a unit, use this if you also need to create similar environments.

Today, we will see how we can export and then import(install) the model store.

Export a Model Store


  1. On the Start menu > All Programs > Administrative Tools, and then click Microsoft Dynamics AX Management Shell.
  2. At the Windows PowerShell command prompt, type the following command, and then press ENTER.

Example:

This command exports the model store to an .axmodelstore file.
For more information, see Export-AXModelStore.

Import a Model Store


  1. On the Start menu > All Programs > Administrative Tools, and then click Microsoft Dynamics AX Management Shell.
  2. At the Windows…

View original post 41 more words

 

The Copy Only Backup… What is it and why use it?

Full Backup in SQL Server 2012 doesn’t brake log chain but Copy_only very usefull for ad-hoc transaction log backups.

Mitch's Pitch

The copy-only backup is actually a very important tool in all production DBA’s arsenal. A copy only backup is essentially a ‘snapshot’ of the database at that point in time that is completely independent from any sequencing of backups used for a restore.

Why is it important some might ask, well, let me explain. Almost all production SQL environments have some sort of back up strategy which includes some combination of full backups, differential backups and/or Transactional log backups. For instance, a full backup is taken on a database every weekend. This creates a starting reference point for a restore.  After the full backup, differential backups are taken nightly with additional transaction log (TLog) backups taken at specified intervals throughout the day to create what is called a log chain. All of these differential and TLog backups are tied directly to the preceding full backup. A Log Sequence Number (LSN)…

View original post 345 more words

 
Leave a comment

Posted by on March 1, 2016 in Uncategorized