How to create a SQL Server backup?

Asked By 20 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Emil Onoon
Answered By 0 points N/A #172560

How to create a SQL Server backup?

qa-featured
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.
Best Answer
Best Answer
Answered By 0 points N/A #172559

How to create a SQL Server backup?

qa-featured

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.

Related Questions