MSSQL

Written by Mangesh on September 18, 2008 – 7:23 am -

How to backup the databases

Backup of MS SQL Server 2005 databases

This is the steps of backup:

1. Open MSSQL Server Management Studio. (Start >>> programs >>> Microsoft SQL server 2005 >>>
SQL server Management studio Express)

2. Connect to MS SQL Server database :
(Connect to server window)
Server name: 192.168.XX.XX\SQLEXPRESS
Authentication: SQL server Authentication OR Windows Authentication
Login: sa
Password: xxxxxx

Then press connect

3. after login to SQL server

1. Expand the Databases
2. select the database test_db
3. right click on database
4. select Tasks >>> select backup
5. then open backup database window
6. Under Backup type select Full
7. Under the destination
8. C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\test_db.bak
9. Enter the path and file name for the backup file
( add this default path and backup should be in .bak format )
10. Press OK
11. backup successfully windows
12. press ok
Done.


Tags: , , , , , ,
Posted in Windows VPS | 1 Comment »

One Comment to “MSSQL”

  1. sql server table Says:

    [...] of and use cases for common table expressions in the SQL Server Manazine InstantDoc #42072. TheMSSQL |How to backup the databases Backup of MS SQL Server 2005 databases This is the steps of backup: 1. [...]

Leave a Comment

RSS

  • Subscribe Me

  • Tag Cloud

  • Archives