Solved

SQL Backup

Posted on 2014-09-11
2
198 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
2 Comments
 
LVL 47

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 60
Help Required 3 94
Find SQL query used by application 3 17
How to construct an if else statement from existing code 6 19
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

776 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