SQL Backup

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 15:09, 1 November 2007 by Jason.Carmichael (talk | contribs) (New page: ==Description== This page will describe the steps necessary to perform a SQL backup. Backups should be created before making any major changes to a database to ensure you can restore them...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Description

This page will describe the steps necessary to perform a SQL backup. Backups should be created before making any major changes to a database to ensure you can restore them if necessary:

Creating a backup with SQL 2005

  1. Log onto the server that you need to create the backup on
  2. Go to Start/Programs/Microsoft SQL Server 2005/SQL Server Management Studio

Start-Programs.jpg

  1. The first prompt will ask you to which server to connect to. Supply the proper information and hit <Connect>

Server Connection.jpg

  1. Expand Databases
  2. Right-click the database you wish to backup
  3. Select Tasks/Backup

Bacukup selection.jpg

Retrieved from "https://wiki.galenhealthcare.com/index.php?title=SQL_Backup&oldid=429"