#CollectionCare

2025-04-26

Let’s talk about data security: Restoring a TMS database

So, yesterday we took a backup of our TMS database. Today, we learn how to restore it. This is also a check you should be doing after having taken your first backup and also regularly after you have taken backups because like I have mentioned here otherwise you can’t be sure you have backed up anything. Or, like a friend of mine who deals with a lot of IT messes put it:

“I bought a book!”
“Are there words inside it?”
“Huh? Of course. I didn’t check, but there are always words inside a book, right?”

Before you haven’t checked, you just assume, you aren’t sure. And if there is one rule every collections professional knows by heart it is this: Never assume, always make sure!

Step 1: Again, log into the server you want the database to restore to and open Microsoft SQL Server Management Studio

You already know how to do that by now. If not, re-read step 1 in this article.

Step 2: Navigate to the Restore menu

Go to the folder “Databases”, right-click on it and select “Restore Database…”

Step 3: Chose your backup file

Up comes a rather bleak screen:

Go to “Device” and click on the three dots …

You get another rather bleak screen from which you choose “Add…”

You are getting a look at your file system from which you select the backup file you want to restore from. You might remember I cautioned you to store it in a place you can easily find it in Step 6 in in the previous article, right?

When you have found the right file, you click “OK”.

On the next screen you also click “OK”.

Step 4: Restore your database

Now you are on this screen again, but now it is populated with your chosen backup, including the date and time it would restore to:

You can see how my database “Leer” (yours might be called “TMS” or something else) is showing up both as the source and as the destination. If you really want to overwrite your current database this is fine, for example because something went horribly wrong with your current database and you want to restore it to an older version.

But if you just want to test if our backup file is okay, you don’t want to do that! Imagine something went wrong with the backup. We would be overwriting our totally fine current database with a corrupted backup! Big mistake!

So, for testing, instead of the “Leer” as destination I simply typed another name. I chose “TMSTEST”:

Then I clicked “OK”.

The database will now be restored to a new destination. If the backup file is okay and you have enough storage space you will get this screen after a while:

You can now click “OK”.

Step 5: Test your database

You should now see an additional database in your databases folder (mine shows up, of course, as “TMSTEST” because I called it that way):

If that worked fine, your backup file is okay. But just because I am a bit anal about my data, just to check, just to make sure, I run the mother of all TMS queries: “Select * From Objects”.

Only when it runs smoothly and the number of objects I get back matches my expectations, I am satisfied.

Housekeeping

Backup files are rather large. Which is logical, because they contain all your valuable data, right? So, after testing to make sure my backup is okay, I deleted that new database again by right-clicking on TMSTEST and choosing “Delete” so it doesn’t clog my server:

Also, because the backup files are so large, I tend to compress them before I move them to a different server. I use the software 7-Zip for it since it proved to be rather reliable (https://www.7-zip.org/). If you don’t have it on your server, you need to install it, first.

Go to your Windows Explorer and find your backup file. Right-click on it, choose “7-Zip” and select the option “Add to [whatever your backup is called].7z”.

You can now see how the backup is compressed. Wait until it is done (fetch a coffee or a tea, this might take a while, depending on the size of your database).

After it is finished, you will see a second file on your file system:

You will notice how much smaller the compressed file is. This is much easier to move to another server, unpack, and restore there, right?

Because I am paranoid I will move the .7z file to a cloud storage that I trust now and try if I can unpack it there without issues. If that is the case I can go back and delete the .bak file and just retain the smaller .7z file.

Take your backups, take them to a safe location, and take good care!

Angela

#collectionCare #collectionsManagement #dataBase #dataSecurity #database #documentation #MuseumDocumentation

Screenshot showing the tree structure from SQL Server Management Studio with the right-click menu enhanced on "Databases" and the menu item "Restore Database..." selected.Restore Database menu from SQL Server Management Studio with no file selected.Same menu as in previous screenshots but with the radio button "Device" selected and an arrow pointing to the three dots menu.
2025-04-25

Let’s talk about data security: How to back-up your TMS database

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.

Step 1: Log into your database server and open Microsoft SQL Server Management Studio

You usually find it fastest if you start typing “SQL Server Management…” into the Windows search box.

Step 2: Enter your credentials

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.

Step 3: Find your database

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”.

Step 4: Navigate to the backup menu

Right click on your database, choose “Tasks” and then “Back Up…”

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.

Step 5: Chose your backup method

You will get to this screen:

Here you can choose if you want to do a full or differential backup (we talked about that here). You select that in the drop-down “Backup type”. We chose “Full” for this backup.

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.

Sometimes you will see a backup file already in the screen below that. If that’s the case, remove it, first.

Then click on “Add…”

Step 6: Add the file you want to back up to

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”.

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.

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.

Once you entered the name, hit “OK”.

Step 7: Take your backup

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.

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.

Take your backup and take care!

Angela

#backup #cataloging #collectionCare #collections #collectionsManagement #dataSecurity #database #DatabaseCareIsCollectionsCare #howTo #museum #museums #security

Screenshot of the search box next to the windows icon, you can see somebody started typing "SQL..." and the option "SQL Server Management Studio 20" pops up as first choice.Login screen of SQL Server Management Studio.Screenshot from SQL Server Management studio navigation tree. The databases file folder is opened so you can see all the databases, the database "Leer" is enhanced so you can see the menues underneath it.
2025-03-11

Heads up: Bug when buying Managing Previously Unmanaged Collections from Amazon

Two things happened today:

I finally got my author’s copies of Managing Previously Unmanaged Collections and I was notified that there is a problem with ordering the book from Amazon:

When you are ordering from Amazon.com and you are on the website of the paperback https://www.amazon.com/Managing-Previously-Unmanaged-Collections-Practical/dp/1538190648/ and then click on the “Kindle” version you are directed to the old 2016 edition of the book.

Conversely, if you go to Amazon in Germany or the UK and are on the “Kindle” version https://www.amazon.de/-/en/Angela-Kipp-ebook/dp/B0D7R1N7KC/ and then switch to the paperback version you get the old version of the paperback.

Just a heads-up, since I learned today that people bought the old version by accident that way.

I do, however recommend buying from your local bookshop or directly from the publisher (https://rowman.com/ISBN/9781538190630/Managing-Previously-Unmanaged-Collections-A-Practical-Guide-for-Museums-Second-Edition) anyway.

#book #bookstodon #collectionCare #collectionsManagement #museum #registrar

2025-02-19

"It’s Not Easy Being Green – The Challenge of Having Poisonous Arsenic Containing Books in a National Library Collection"

Artikel (#openacces) van de collega's van #Collectiebehoud #Collectioncare van @kbnationalebibliotheek over #arsenicum als kleurstof op #boekbanden e.d. In #Studies in #Conservation:

doi.org/10.1080/00393630.2025.

ICON Care of Collections GroupCollectionsCare_ICON@historians.social
2024-12-27

CCG Reading Group discusses OA articles about preservation, collection care & conservation. We're an accountability partner for reading new or established research.

Enroll in the second session (no account should be required to sign up):

doodle.com/sign-up-sheet/parti

We meet 1st Tuesday, every two months for 1 hour,  16.00 GMT.

4 Feb via Zoom.

The reading options being chosen during enrolment linked above.

#CollectionCare
#Preservation
#ProfessionalReadingGroup

Line drawing depicting a row of books. Pest trap at left. Environmental monitor positioned at far right.
2024-11-24

Book bindings have memory. These two volumes recently removed from exhibition show the possible consequences of prolonged display.

The left boards will eventually settle back into a more horizontal position given time and careful handling.

#CollectionCare
#Preservation
#Exhibitions
#GLAM
#BookConservation

@bookhistodons

Rebound manuscript in a wedge shape more narrow at left spine edge with wider opening at right foredge.

Original leather adhered to front board.Bound manuscript in a wedge shape more narrow at left spine edge with wider opening at right foredge.
2024-11-23

The end of an exhibition is always a little moment of melancholy.

Decanting the cases is a quiet and efficient process.

However, there is more work for the #CollectionCare team: condition checks, post display conservation, sorting and labelling cradles for future use...

#Exhibitions
#GLAM

ICON Care of Collections GroupCollectionsCare_ICON@historians.social
2024-10-02

Collection Moves day - talks, tours & AGM (hybrid)

Hosted at Birmingham Museum Collection Centre (MCC), we will explore the perennially important topic of collection moves incl:
-Unique requirements
-Project mgt & collection tools
-Item handling & stabilisation
-Hints & tips

Proposed schedule BST:
9.00 MCC tour (optional)
10.15 Welcome
10.30 Talks
13.30 AGM
14.30 (BMAG) tour (optional)

#CollectionCare

icon.org.uk/events/care-of-col

Line drawing of trolley, crates, items surrounded with fragile tape.

Hosted at Birmingham Museum Collection Centre (MCC), we will explore the perennially important topic of collection moves. Whether moving a collection from one store floor to another or to another building, moving our collections is a frequent part of a collection care conservator roles.

We are hosting talks covering topics:

Collection moves unique requirements
Project management methodologies and collection tools like location data
Addressing item handling and stabilisation needs
Hints and tips for big and small collection moves
Interesting case-studies like remaining open while moving collections
Approximate schedule BST:
9.00 - 10.00 MCC tour (optional)
10.15 Welcome and introduction to MCC, Birmingham, UK
10.30 - 11.30 4 x 15 minute talks
11.30 - 11.40 Q&A
11.40 - 11.55 Break
11.55 - 13.20 5 x 15 minutes talks
13.20 - 13.30 Q&A
13.30 - 14.30 AGM and lunch
14.30 - 15.30 Birmingham Museum and Art Gallery (BMAG) tour (optional)

Please note to in-person or virtual attendees, we intend to record talks for later publication but will honour contributor requests to not record and/or publish.

The MCC is wheelchair accessible and has parking availability for approximately 30 vehicles. Please let us know about personal mobility issues as there is a short set of stairs in the entry way that can be avoided with prior arrangements.
ICON Care of Collections GroupCollectionsCare_ICON@historians.social
2024-09-21

We received really fabulous talk proposals from small and large organisations in the UK and further afield.

Thank you to everyone who submitted. We'll confirm talks with speakers by 27 September.

historians.social/@AmazingMeag

In the meantime, save the date for in-person or virtual attendance on 24 October.

Tickets will become available at:
icon.org.uk/events.html

#CollectionCare
#CollectionMoves
#GLAM
#Archives
#Libraries

Line drawing showing heritage items being readied for shipping.  Trolley with labelled boxes, a wooden crate, a vase in an open box, a sculpture wrapped in white material.

Save the date and apply to talk at our 2024 Care of Collections Annual General Meeting themed around collection moves.

Hosted at Birmingham Museum Collection Centre (MCC), we will explore the perennially important topic of collection moves. Whether moving a collection from one store floor to another or to another building, moving our collections is a frequent part of a collection care conservator's role.

We are looking for talks of 10-20 minutes long to be delivered live either onsite or offsite or pre-recorded.

Possible topics include:
- What unique requirements are part of collection moves?
- What project management methodologies work for collection moves?
- How are training needs addressed for collection moves teams?
- Hints and tips for collection moves, both big and small
- Interesting case-studies

Please send abstracts, of no more than 300 words, to iconcareofcollections@gmail.com.

Selected speakers will be notified by midnight GMT on Friday, 27 September. 
Any pre-recorded talks, slide decks, etc. will need to be received by midnight GMT on Friday, 18 October.

Please note we intend to record talks for later publication but are happy to not publish upon request.
2024-09-04

On the conservation bench today is two pieces of parchment sewn together. It was surface cleaned using chemical sponge (see upper left corner of second image).

Mask and gloves on for personal protection. Cleaning this to increase text visibility for cataloguing.

Lambeth Palace Library
Arches/E/4/

#CollectionCare
#Manuscripts
#OnTheConservationBench
#Exhibitions
#Archives

@histodons  #histodons

Background: grey conservation bench
Foreground: Two open box halves with slightly discoloured parchment stacked. Most prominent piece is covered in black fine dirt. Second piece of parchment is heavily creased and crumpled with heavy layer of black dirt.Background: Formerly white tray made of blotter. Upper left corner full of black sponge pieces.
Foreground: Most prominent piece is heavily discoloured changing from pale cream to orange/brown. covered in black fine dirt. Nearly disconnected piece is still heavily creased and crumpled.
2024-09-01

Lovely to see #Conservators make it onto the credits poster at the "Six Lives" exhibition at the #NationalPortraitGallery, London.

It's a good exhibition.

#CollectionCare
#Exhibitions

Dark green poster background with white text.
Title: Six Lives
Followed by a list of teams who are part of the project including curator, designers and conservators amongst others.
2024-08-03

On the conservation bench today, yes on Saturday for our once a month weekend opening, is a 15-16th century parchment roll that I'm conserving.

The joins between membranes are delaminating and need re-adhering before it goes on display early February 2025.

Lambeth Palace Library
MS 1170

#CollectionCare
#MedievalManuscripts
#OnTheConservationBench
#Exhibitions

@histodons  #histodons

A roll of parchment with black manuscript with red and green graphic elements. Royal names are decorated with gold. The parchment membranes are delaminating at the right side.A roll of parchment with black manuscript with red and green graphic elements. Royal names are decorated with gold. The parchment membranes are re-adhered on the right side.
2024-07-16

One week rest after cases are secured in the Exhibition Room until 'Her Booke' decant in November. But no rest for the Collection Care team as we're already planning and condition reporting for the February 2025 exhibition.

#CollectionCare
#exhibition

@bookhistodons
@histodons

Rebound manuscript showing brown leather spine and corners. Gold tooling over spine.

Lambeth Palace Library MS 427Parchment folios. Iron gall ink manuscript with red pigment and possibly a silver decorated initial.

Lambeth Palace Library MS 427 f.2v-3r
2024-06-23

@Rhube
All book conservators, look away now.

#CollectionCare

2024-04-25

@histodons @medievodons @librarians

One of the amazing things about working with collections at #LambethPalaceLibrary is that you can take yourself up to the stores to see a figure featured in a volume.

In this case it is the decoration featuring Grosseteste in our MS522 described in Dennis Duncan's Index, A History of the.

#library
#CollectionCare

Book cover with title:
Ind x, A History of the by Dennis DuncanA person leaning over a bound manuscript on a desk in a reading room.
2024-04-03

It might sound trivial at first that a beetle isn’t a household article but if you look closer, it isn’t. When a coffee cup breaks during a move you just go ahead and buy a new one. It gets annoying if it belonged to a set that went out of production a while ago. It becomes an irreplaceable loss if said coffee cup was connected to a special memory, for example because it belonged to your great-grandmother or because your child made it themselves.

Museum collections are pretty similar to the last case but now it isn’t just about the memory of one person or a family but about the history of humankind. Which means that the loss is far more grave.

Now, when it comes to collections of natural history an additional aspect comes into play: here, the loss of one object equals an irreplaceable loss of information that is important for current and future research. This is of course also true for art and history collections but in these cases at least the loss can be tempered if the object was well documented and digitized. Our beetle, on the other hand, is a repository in itself. Only this one specimen was collected at precisely that time and precisely that place and preserves all information about its environment at that time. No form of documentation and digitization can anticipate all the questions future generations of researchers will have. The preservation of that information is only possible by preserving the beetle itself.

Beetles in a museum collection, photo by Markéta Klimešová via Pixabay

Not all beetles belong in a collection

Because the preservation of the objects is so important generations of researchers tried to keep them out of harm’s way. Now, natural history collections are especially attractive to pests and therefore every biocide the chemical research and industry discovered in the last centuries was used in them. DDT with insect collections, arsenic with taxidermies, mercury in herbaria, from nerve toxins to organophosphates you are handling everything that can harm your health or even kill you.

In case of a collections move this means you have to deal with two aspects absent from a conventional household or office move:

  • You have to prevent pests from getting to your objects during transit. This means that the items you are moving need to be packed the way no pests can get inside and that you have airlocks and quarantine stations on your transport routes so you can be sure nothing got infested.
  • When planning the work to be done in preparation for the move you have to keep in mind that you are handling toxic goods. In the past the use of biocides was rarely documented and the only way to be sure what you are dealing with is gauging your collection before you actually start working. This will tell you which precautions you have to take previous to packing and moving and what you have to account for in the new storage.

On top of that there is another danger: the objects themselves. Some of them are toxic or radioactive and therefore you have to treat, transport, and store them differently than your common coffee cup.

Packaged beetles – No package tourists

Transports get quickly done if things can be standardized. You know that from moving house: if you can use standard packing crates they will fit seamlessly into the truck. All you have to do is pack them in a save and reasonable way and avoid overloading.

In natural history collections there are many things that can be standardized: Our beetle will most likely be stored with a lot of its fellows in one drawer and this drawer can be neatly packed and moved with other, similar drawers. But a lot of other specimen don’t do their collections managers the same favor.

Many are stored in glass containers filled with alcohol or formaldehyde which means they are not only fragile but also sensitive to vibrations and their contents inflammable and noxious. You are also not allowed to transport them through a water protection area, which you have to account for when planning the shipment routes.

This is but one example of the many special, non-standard cases you have to deal with when planning the move of a natural history collection. Some specimens are so heavy you need to hire specialized riggers to move them. Others are so fragile you need to get special crates built for them. Many are both heavy and fragile. Then others are preserved by freezing them and if you want to move them you have to make sure the cold chain stays uninterrupted. A taxidermized giraffe or the skeleton of a whale can keep a whole team of experts occupied for days just to find the best way to move it.

Storing beetles – Not a case for your local furniture store

If you have read this far you already guessed it: if you want to store a natural history collection then this storage space needs to fulfill a lot of criteria. It has to deter pests, have a stable room climate, needs a good air circulation and has to be equipped with furniture that allows objects to sit in them for centuries without being damaged yet be easily accessible for research.

Different kinds of specimen collections can have very different requirements. High humidity is a problem for most of them because it enables mold and attracts pests but a room being too dry can cause problems as well. Fluctuations in temperature can rupture the skins on taxidermy specimens and cause fossils to break. An insufficient air ventilation might cause a high concentration of toxics in a room and/or introduce mold. Good collections storage provides the appropriate climate for each of its collections. They are built the way that even in case of an emergency that results in failure of all technology a good storage climate can be re-established by conventional means in such a short time that no permanent damage or even loss of objects happens.

Accessibility is part of a safe collections storage. You need to be able to remove one specimen in a way the other objects stored with it stay unharmed. Our beetle in its drawer is a real space saver, here. Other specimens need far more space. For example, it has to be possible to remove a specimen stored in a jar of liquid from its shelf without having to move other containers. This means you can’t fill your shelves to maximum packing density and you need more storage space but for a good collections storage this is inevitable.

For all these problems there are good solutions but they are not available in your local furniture or hardware store. There are experts and manufacturers who have specialized on these topics.

Whatever is planned for your final storage has consequences for your move: If your beetle is right now in a drawer that is contaminated by pesticides or simply doesn’t fit into your new storage furniture this beetle and its comrades have to move to a new clean and fitting drawer before the move. It is rather common that one big collections move means a lot of smaller moves beforehand.

Ask the beetle anytime

When art or history collections move they often put parts of their activities in collections, exhibitions, and research on hold. A natural history collection that is part of an international network of research institutions in most cases can’t afford this comparative luxury.

In effect, this means that the move has to be planned and executed very different from other moves. It isn’t possible to pack whole collections and store them in a compact and largely non-accessible way until the big move takes place. It must be possible to get access to every collection and every specimen at any given time.

In general, there are two ways of dealing with that: You can limit the time an object is actually crated and in transit, which means that preparation, packing, moving, unpacking, and storing is a matter of just a few days. Or you can crate the specimen in a way that access is possible at any time and without endangering the object itself and the objects packed with it even during the move. Both possibilities have advantages and disadvantages but they both mean that you need more space both in the location you are moving from and in the one you are moving to. It means as well that you need more time and more staff compared to other types of collection moves.

To sum up: Why moving beetles needs a sum of money

With your own experience of moving houses in mind the amount of time, money, and staff it takes to move a museum collection seems to be comparably high. An impression that quickly vanishes when you know the reasons.

Make no mistake, no museum collection is as such “easier” or “harder” to move. Every type has its own, unique challenges. But natural history collections are for sure among the most complex ones you will encounter. And they have a disadvantage: while everybody intuitively understands that you can’t just throw the Mona Lisa on the back of an old truck, a beetle is at first sight “just” a beetle. It isn’t at all obvious that this beetle is a repository that holds perhaps more important and undiscovered information than the well researched and documented artwork by Leonardo da Vinci.

This adds an additional challenge to a move that is already made complex by the variety and sheer masses of objects that have to be brought safely from A to B: the general public has to understand that a beetle is not a coffee cup.

Perhaps this article can help a bit with that.

Angela Kipp

https://world.museumsprojekte.de/a-beetle-is-not-a-coffee-cup-why-moving-natural-history-collections-is-not-like-moving-house/

#collectionCare #collectionsManagement #collectionsMove #documentation #insectCollections #naturalHistoryCollections

Beetles in a museum collection. The insects are sitting on a acid free cardboard which is pinned with the accompanying label to the drawer or showcase.
2024-03-28

@forestfern @medievodons @histodons @bookhistodons

Good question. They are a bean bag construction. The volumes need to be in good stable condition for me to use them as they can cause damage to particular types of bindings.

#CollectionCare

2024-02-03

On the conservation bench today, yes on Saturday for our once a month weekend opening, is a #book from 1552 for which I am writing an exhibition condition report.

The left endleaf is paper #ManuscriptWaste. Beneath the pastedown and just visible at the tail is a parchment manuscript #fragment.

Lambeth Palace Library
1552.1**

#CollectionCare
#BookConservation
#OnTheConservationBench
#Exhibitions

@histodons  #histodons 
@bookhistodons
@fragmentarium
#manuscriptfragment

Book open at left endleaf. Left endleaf has a donation plate dated 1967.

Right endleaf is manuscript waste rotated 90 degrees. Manuscript is iron gall ink.Book open at left endleaf that is manuscript waste rotated 90 degrees. Manuscript is iron gall ink.
Right page is the title page The Christen State of MatrymonyeParchment stub made of recycled manuscript waste.

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst