Solved

SQL Backup

Posted on 2009-03-31
2
346 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 125 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 125 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

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 …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

705 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now