Solved

"Real Time" backups of SQL Server databases

Posted on 2011-09-21
5
238 Views
Last Modified: 2012-05-12
I have a client who's using SQL Server database for a medical office app.
I'm not a SQL Server guy.

The question is how to grab backups of today's data (say every 4 hours during the day) so that any losses are minimized.

What's best practice / tools?
0
Comment
Question by:Fred Marshall
[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
  • 3
  • 2
5 Comments
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 36577924
You can use SQL native backups and choose between the two options below:

FULL backup daily and T-log backups every 4 hours if database is in FULL recovery
FULL backup daily and differential every 4 hours for SIMPLE recovery mode

Both are very easy to setup from SQL SSMS under Management/Maintenance plans

How to: Back Up a Database (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms187510(v=SQL.90).aspx

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

0
 
LVL 26

Author Comment

by:Fred Marshall
ID: 36578527
One of the concerns which must be a normal one is this:

If workers have various records open then what happens when a backup is done?
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 36580467
In order to take a FULL or T-Log SQL backup the database is fully operational and ON-Line so there is no need for concern from that point of view. From "Point in time" recovery perspective please read details at link below and briefly - you should be able to recover to the last transaction backed up by the last T-log:

How to: Restore to a Point in Time (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms190982(v=sql.90).aspx
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 36580482
0
 
LVL 26

Author Closing Comment

by:Fred Marshall
ID: 36596678
That's what I needed.  Thanks!
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 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