"Real Time" backups of SQL Server databases

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?
LVL 27
Fred MarshallPrincipalAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
Fred MarshallPrincipalAuthor Commented:
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
 
Fred MarshallPrincipalAuthor Commented:
That's what I needed.  Thanks!
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.

All Courses

From novice to tech pro — start learning today.