How can we create Bakup database in sql server 2005

Accepted answer

Follow this simple steps

1.open sqlserver.
2. Right Click on ur Database for which you want to create Backup.
3. You can see Tasks Option is there.
4.Within a Tasks option Back up Option is there,click on it.
5.open window will open Click on ok button it will by default create backup under
C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup Folder

if you want to change then click on add Button and click browse button give path where u want to store backup file and give ur backup file name.

0

Shirsendu Nandi15y ago

good solution for ankit

0

Mayur Gujrathi15y ago

Try this

backup database  to disk  = 'c:\.bak'

0

Vijay Yadav15y ago

Hi,
Open SQL server managemnet studio and then right click on your database and choose Task and under task choose Backup then window will get opened and then create backup of your database.

0