Solved

SQL Backup

Posted on 2014-09-11
2
207 Views
Last Modified: 2014-09-15
Please analyze.  SQL full backup everynight(NOT copy_only)  at 7pm.  Log file(NOT copy_only) every night at 8pm.  Log backup every 4 hours(COPY_only).  My network admin wants the copy_only log backup because it will reduce the number of logs backup files to restore in a disaster.  The full backup at 7 will create checkpoint and the log backup at 8 is regular.  My question is:  will the copy_only log backups be of any value.  on paper, the copy_only log in the afternoon should contain all transactions since the last log backup(8 pm the night before).  Am I missing something?

Thank you,
0
Comment
Question by:BUCKBERG
[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 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40318697
I can't understand the option of COPY ONLY for transaction log backups. That won't truncate the logs and will be a waste of space. COPY ONLY option should be used only for special purposes (extra backup without affecting the backup chain).

Also don't understand if you have a full backup at 7PM and one hour later a tlog backup, you'll only have the transaction log truncated again 24h later.

You should review your backup strategy. If the idea is to reduce the number of log backups then you are missing a differential backup.
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40323425
Agreed.  That's a very odd backup structure.

So your network admin does SQL db recoveries?  Do you not have a DBA?!
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

717 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