How can we create Bakup database in sql server 2005

Question

hello Guys how r u All ? Q: My Question is that, how can we create bakup of our database with all records , in sql server 2005 Reply Soon Thanks.

Ankit Nandekar · 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.

Shirsendu Nandi · Answer

good solution for ankit

Mayur Gujrathi · Answer

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

Vijay Yadav · Answer

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.

How can we create Bakup database in sql server 2005

Answers (4)