How to create a SQL Server backup?

Asked By Martha Nelson 20 points N/A Posted on - 10/17/2012

Hello experts,

How to create a SQL server backup? I am using SQL server for my system with java programming language. I just want to ask if how to create a back up for my database so that I can save it in my flash drive or external hard drive to avoid problem in the future.

Thank you.

• Status: Open
• Question Views: 1045
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Emil Onoon

Go To Solution

Answered By Adams DILAN 0 points N/A #172560

How to create a SQL Server backup?

Hello Martha Nelson,

 

What I provided below is a link on how to create a back up on your SQL server. There are many ways on how to backup a single or even on multiple databases, You can see here the syntax, pictures, and the tutorial on how to backup  your SQL server.

 

Backup Job in SQL Server: How to Create for Single/Multiple DBs

 

Good luck. Hope this helped you.

About Adams DILAN

Questions
3

Answers
97

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 10/22/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Emil Onoon 0 points N/A #172559

How to create a SQL Server backup?

Hi Martha,

 

I will help you to create a back up of your database in SQL Server. First go to Object Explorer. Then right click on the database name you want to take back up. Choose Tasks and Click on Backup. Then you will see a pop-up window. Click Add to a location where you want to store it so that you can restore it later. Click Ok. It will be backed up.

About Emil Onoon

Questions
0

Answers
198

Best Answers
58

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: MS SQL Server