[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Backup

Posted on 2009-03-31
2
Medium Priority
?
358 Views
Last Modified: 2012-05-06
I 'm currently in the midst of establishing a backup procedure for my SQL 2005 databases. I'm scheduling a maintenance plan that occurs nightly. The backups will then be written to tape via my backup software. My question is, should the transaction log first be backed up followed by the full database backup? Or, should the full database backup take place followed by the transaction log backup.

Thanks!

scheduling nightly backups to take place from SQL maintenance. Then these backups will be written to tape by my backup software.
Thanks!
0
Comment
Question by:Danstr1
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 24031920
the transaction log should always be after the full backup...otherwise the trans log backup won't do you any good.
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 500 total points
ID: 24031942
If you take a Full Backup, then there is no need to perform Transaction log backup at all. Full Backup truncates all inactive transaction logs in LDF files.

Ideal procedure for doing backup is:

1. Full Backup at periodic intervals -- Say once per week
2. Differential Backup between Full Backups -- Say once per day.
3. Transaction Log Backup between Differential Backup - Say 4 or 6 times per day.

Time lines provided above is an example and varies depending upon your requirement.

Hope I explained you to solve your issue.
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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Integration Management Part 2
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

825 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