Solved

MS SQL FULL BACKUP

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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…
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

733 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