how to backup database sql server

how to backup database sql server with (SQL Server Management Studio)

  • firstly, must be connecting with database will you backup
  • After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree
  • Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
  • Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.

    • backup sql server

  • In the Database list box, verify the database name. You can optionally select a different database from the list.
  • You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE).
  • You can  change name, description and file location to backup database

backup sql server

Leave a Reply