Sql server
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.
- 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
