(877)-718-2617


How to create database backup

MS SQL Server 2005 (Express) Backup

To create MS SQL Server 2005 (Express) database backup, you need Microsoft SQL Server Management Studio Express. It can be freely downloaded and installed on the server or your PC.

Run SQL Server Management Studio, find TargetProcess database and right click on the database name. Click Tasks and find Back Up... action

mssql 2005 backup

Select location for database backup file and click OK

mssql 2005 database backup locationa

MS SQL Server 2000 Backup

To create MS SQL Server 2000 database backup, you need Microsoft SQL Server Enterprise Manager.

Run Enterprise Manager, find TargetProcess database and right click on the database name. Click Tasks and find Backup Database action

mssql server 2000 database backup

Select location for database backup file and click OK

mssql server 2000 database backup