?
Solved

SQL Backup

Posted on 2009-03-31
2
Medium Priority
?
354 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
[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 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

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 …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

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