How Do I Back Up Company Database?

See Also

 

To back up the Microsoft SQL Server Standard or SQL Server Express database (2008 or later) containing your EngineerOffice database, do the follow:

  1. Make sure you are logging in as an administrator on the Windows server.
  2. Open the SQL Server Management Studio.
  3. On the Connect to Server screen, verify the correct server name (for example, Username\SQLExpress) is selected.
  4. Select Windows Authentication from the Authentication drop-down list and click Connect.
  5. After connecting, expand the Databases list and right-click on the database to be backed up.
  6. From the right-click menu, select Tasks > Back Up.
  1. On the Back Up Database screen, in the Destination section, click Remove to delete the standard backup location (for example, C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Backup\DatabaseName.BAK).
  1. Make sure the Disk option is selected (not Tape) and click Add to specify a new backup location.
  2. Browse to select a new backup destination folder. Make sure Files of type is set to Backup Files (that is, *.BAK extension) and enter a backup filename.
  1. Confirm the full directory path and then click OK.
  2. On the Back Up Database screen, verify Full is selected from the Backup type drop-down list and then click OK to start the backup process.