RegistrarTrek<p><strong>Let’s talk about data security: How to back-up your TMS database</strong></p><p>This is a step-by-step guide on how to backup your database if you are using a product of The Museum System (TMS) by Gallery Systems. If you use a different system it will work differently. Ask your vendor about it.</p><p><strong>Step 1: Log into your database server and open Microsoft SQL Server Management Studio</strong></p><p>You usually find it fastest if you start typing “SQL Server Management…” into the Windows search box.</p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-25-08-27-55.png" rel="nofollow noopener noreferrer" target="_blank"></a><p><strong>Step 2: Enter your credentials</strong></p><p>You will be prompted to enter your login credentials. If you are on NT Authentication usually all you have to do is click on “Connect”. If you have another form of authentication you will have to enter those login details. Your IT will tell you what to enter in that case. </p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-25-08-30-13.png" rel="nofollow noopener noreferrer" target="_blank"></a><p><strong>Step 3: Find your database</strong></p><p>In the tree hierarchy, open the folder “Databases” and find your database. It is usually called something like “TMS”. In my case it is called “Leer”.</p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-18-19-34-53.png" rel="nofollow noopener noreferrer" target="_blank"></a><p><strong>Step 4: Navigate to the backup menu</strong></p><p>Right click on your database, choose “Tasks” and then “Back Up…”</p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-18-19-34-26.png" rel="nofollow noopener noreferrer" target="_blank"></a><p>If that option is greyed out, you might not have the rights to do this. in which case you should talk to your IT so you get those rights. </p><p><strong>Step 5: Chose your backup method</strong></p><p>You will get to this screen:</p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-18-19-35-16.png" rel="nofollow noopener noreferrer" target="_blank"></a><p>Here you can choose if you want to do a full or differential backup (<a href="https://world.museumsprojekte.de/lets-talk-about-data-security-backups/" rel="nofollow noopener noreferrer" target="_blank">we talked about that here</a>). You select that in the drop-down “Backup type”. We chose “Full” for this backup.</p><p>As a destination, usually “Disk” is fine, since you probably want to have the backup on your computer first and then transfer it to a cloud later.</p><p>Sometimes you will see a backup file already in the screen below that. If that’s the case, remove it, first. </p><p>Then click on “Add…”</p><p><strong>Step 6: Add the file you want to back up to</strong></p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-18-19-36-09.png" rel="nofollow noopener noreferrer" target="_blank"></a><p>By default, Microsoft suggest a rather cryptic sub-folder for your backups. I’d recommend adding a folder in a more prominent place that you can easily find and back up to there. You can see mine being “M:\Backups”.</p><p>Enter a file name for your backup. This can be the date you took it (Best Practice is to note the date in a year-month-day format so you can easily sort by date if you have multiple backup files) or a significant pointer to when you took it, for example “BeforeUpgradeTo995” if this is your backup before upgrading to a new version. Don’t forget to add “.bak” as a file ending, otherwise you might run into difficulties to restore it, later.</p><p>You can see that I called mine “AfterCI2025.bak” because it is the backup I took after adding a significant amount of information from our user conference. </p><p>Once you entered the name, hit “OK”.</p><p><strong>Step 7: Take your backup</strong></p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-18-19-36-25.png" rel="nofollow noopener noreferrer" target="_blank"></a><p>After that you just need to click on “OK” and your backup will be taken. If you have enough disc space in your chosen location, all is fine, otherwise it will throw an error message.</p><a href="https://world.museumsprojekte.de/wp-content/uploads/2025/04/Screenshot-from-2025-04-18-19-38-45.png" rel="nofollow noopener noreferrer" target="_blank"></a><p>That was it. Wasn’t too hard, was it? And now you are good to go and bring your database to a safe location. I will do another post on how to compress the backup and restore it on another server.</p><p>Take your backup and take care!</p><p><em>Angela</em></p><p></p><p><a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/backup/" target="_blank">#backup</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/cataloging/" target="_blank">#cataloging</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/collection-care/" target="_blank">#collectionCare</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/collections/" target="_blank">#collections</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/collections-management/" target="_blank">#collectionsManagement</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/data-security/" target="_blank">#dataSecurity</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/database/" target="_blank">#database</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/databasecareiscollectionscare/" target="_blank">#DatabaseCareIsCollectionsCare</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/how-to-2/" target="_blank">#howTo</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/museum/" target="_blank">#museum</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/museums/" target="_blank">#museums</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://world.museumsprojekte.de/tag/security/" target="_blank">#security</a></p>