?
Solved

MS SQL FULL BACKUP

Posted on 2010-09-02
2
Medium Priority
?
585 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 1000 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 1000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses

770 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