SQL Database automatic back up

sql backup lan
chuck picture chuck · Jan 31, 2013 · Viewed 79.7k times · Source

I have an SQL database - I need to back it up everyday (at a minimum) - preferably multiple times a day - automatically so it definitely gets done.

I'm running Windows which the SQL database is stored on.

What programs (prefer free ones) can I use to back it up - I'm completely new with SQL so if you're gonna explain something - do it in layman's terms thanks (:

It needs to get backed up to another server (on the LAN).

Answer

pringgo_setiko picture pringgo_setiko · Jul 4, 2013

Auto Backup Database Using Maintenance Plans

Simple Step :

  1. Go To SQL Server Configuration Manager > SQL Server Services > Run SQL Server Agent (Set it to Run Automatically)

  2. Go To SQL Server Management Studio, Find TAB Management > Maintenance Plans. Right Click > Maintenance Plans Wizard.

  3. Text your maintenance plans, ex: DailyBackup. Select Option button : Single Schedule for entire task.

  4. Click Configure > Set Schedule according your demands.

  5. Select Maintenance tasks. for this case, you choose Full Database backup.

  6. Click Next, then define which database to backup, set backup location, and backup extension.

  7. Click Next, Choose your report mode, then Finish.

Related questions

How can I backup a remote SQL Server database to a local drive?

I need to copy a database from a remote server to a local one. I tried to use SQL Server Management Studio, but it only backs up to a drive on the remote server. Some points: I do not have …

Read More
How can I retrieve the logical file name of the database from backup file

I was looking into the steps of how to Restore Database Backup using SQL Script (T-SQL). Here are the steps: Database YourDB has full backup YourBackUpFile.bak. It can be restored using following two steps: Step 1: Retrieve the logical file …

Read More
SQL Server: how to query when the last transaction log backup has been taken?

I would like to query for all databases (in SQL Server 2008 instance) date when the last transaction log backup has been taken. How to do that? I know that this information is somewhere, but I don't know where.

Read More