How to Copy SMS Messages From an iPhone to a PC

Though iTunes makes it obvious that it saves contacts, calendar and other information via the tabs it shows and your sync options, one of the things it does not make obvious is that it also backs up call logs and text or SMS messages. It makes restoring all of the settings and options on your iPhone easy if there is a problem and you have to do a hard reset, or if you want to transfer your information to a new iPhone.

...
Save backups of your SMS conversations on your PC to restore to a new iPhone.

Step

Download and the newest version of iTunes onto your PC and double-click the .EXE file downloaded to install it.

Step

Launch iTunes from the "Start" menu and the "Applications" sub-menu.

Step

Plug your iPhone into your PC using the USB dongle and cradle.

Step

Locate your iPhone under "Devices" in iTunes and right-click on it. Click the option to "Back Up," which saves a variety of settings to your iTunes installation, including your SMS conversations.

Step

Navigate to the file with your saved text messages. The directories with this file may differ depending on which version of Windows you run, but it may be located in one of the following directories:

Step

C:\Documents and Settings[your username]\Application Data C:\Users[your username]\AppData\Roaming C:\Users\user\AppData\Roaming\Apple Computer\MobileSync\Backup

Step

The file with your saved text messages is a SQLite database with a 40 or 44 character hexidecimal name. The file extension is either .MDDATA or .MDBACKUP.

Step

Right-click on the SMS messages database and open it with your favorite SQLite database editor or browser, including SQLite Maestro, RazorSQL or SQLite Database Browser. This allows you to see the information about the text messages as well as the texts themselves.