As a best practice, create a backup of the MDT DB before modifying the tables and views in it. Create a backup of the MDT DB using:

·     SQL Server Management Studio. For more information on how to perform database backups using this method, see “How to: Back Up a Database (SQL Server Management Studio)” in SQL Server Books Online, included with SQL Server.

·     Existing SQL Server backup solution in your organization. For more information on how to perform database backups using this method, see the documentation for your backup solution, or contact your DBA.

Related Topics

Extending the MDT DB Schema