Restoring backup files for Microsoft SQL Server

Use the Microsoft SQL Server database management tool to quickly and conveniently restore backup files for sample databases.


  1. On the computer where you installed TM1® server, go to the following directory:

    tm1_location/webcontent/samples/datasource/Source files/sqlserver

  2. If required, copy the backup files for the samples databases to your database backup directory.
  3. Restore the database from a device, and ensure that the restore locations are correct for the .ldf and .mdf database files.
  4. Create at least one user who has select permissions for all the tables in the restored databases.