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
Solved

MS SQL FULL BACKUP

Posted on 2010-09-02
2
580 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
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.

856 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