Backup and restore database on Microsoft SQL Server 2005 This post will shows a step-by-step guide to backup and restore a database between two Microsoft SQL Server 2005 instances. By using backup, you can backup a database without interrupt any transactions on the database. In the example below, I will try to backup a database from SQL Server 2005 and restore the database to another SQL Server 2005 Express Edition. Backup a database Now I will backup AdventureWorks database on BKKSQL2005 which runs Microsoft SQL Server 2005 to a file. Connect to source server. Open Microsoft SQL Server Management Studio … Continue reading How to backup and restore database on Microsoft SQL Server 2005