.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Steps for backup file in sql server

Posted By:Maverick       Posted Date: May 17, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

Step by step process to take backup (.bak) file in sql server

Now I will backup AdventureWorks database on BKKSQL2005 which runs Microsoft SQL Server 2005 to a file.

Step 1 : Connect to source server. Open Microsoft SQL Server Management Studio and connect to  your database.

Step 2: Right-click on the AdventureWorks database. Select Tasks -> Backup.

Step 3 : On Back Up Database window, you can configure about backup information. If you're not familiar these configurations, you can leave default values. Here are some short descriptions.

    1. Database - a database that you want to backup.
    2. Backup type - you can select 2 options: Full and Differential. If this is the first time you backup the database, you must select Full.
    3. Name - Name of this backup, you can name anything as you want.
    4. Destination - the file that will be backup to. You can leave as default. Default will backup to "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup".
    5. Click OK to proceed backup.

 Step 4 : Wait for a while and you'll see a pop-up message when backup is finished.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend