Solved

"Real Time" backups of SQL Server databases

Posted on 2011-09-21
5
232 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
  • 3
  • 2
5 Comments
 
LVL 39

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 25

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 39

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 39

Assisted Solution

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

Author Closing Comment

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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

816 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

12 Experts available now in Live!

Get 1:1 Help Now