Solved

MS SQL FULL BACKUP

Posted on 2010-09-02
2
577 Views
Last Modified: 2012-05-10
Hello
I have a MS SQL 2008 R2 server.and we installed some programs which uses mssql database.
Now brand-new database system i would like to FULL BACKUP.
Can some one teach me how can i do FULL MS SQL BACKUP? and about ms sql backup plan.
which plan do i need to create?
Thank you
0
Comment
Question by:linuxdebian
2 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 250 total points
ID: 33586373
Either you do everything by script. lookat http://ola.hallengren.com/
or
utilize maintenance plans. You should create a full backup, if db is in full recoverymode you also must create transactional backup. Indexoptimization and integritycheck is also good. Make sure you check the box for verify backup files. Takes double time ofcourse, but it's worth it (if you have the time), because you dont want a backup solution, rather a restore solution

And dont forget to try and restore databases every now and then, as a new name, or over existing database (better be a test system).

Regards Marten
0
 
LVL 16

Assisted Solution

by:JammyPak
JammyPak earned 250 total points
ID: 33586599
not sure how this ended up in the Linux zone...

here you go
http://msdn.microsoft.com/en-us/library/ms187510.aspx
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now