• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

SQL Backup

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
Danstr1
Asked:
Danstr1
2 Solutions
 
chapmandewCommented:
the transaction log should always be after the full backup...otherwise the trans log backup won't do you any good.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now