Backing up the Umbraco database

Transferring the Umbraco database from the local developing system to the running system (and back) is quite simple with SQL Server 2008 Management Studio Express. It is also possible to manually backup the running system with this program.

Management Studio 2008 information: http://technet.microsoft.com/en-us/library/ms365247.aspx

Download-link: http://go.microsoft.com/fwlink/?LinkId=144346

The following steps are required (Management console needs to be installed):

1. Connect to the database.
2. Expand the folder "databases" and select the desired database.
3. In the context menu [right-click] open > Tasks > generate scripts...
4. Confirm the script assistant with > next
5. Select database > next
6. Use the following configuration:
   • Drop as Skript: True
   • Include 'IF NOT EXISTS': True
   • Create script for Server: SQL Server 2005
   • Create script for data: True
   • Then click > next
7. Choose object type: select in table > next
8. Select tables: Select all > next
9. Output options: select write script in file > choose meaningful filename > next > Finish
10. After successful generation > close the assistant