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
Solved

"Real Time" backups of SQL Server databases

Posted on 2011-09-21
5
234 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 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 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 26

Author Closing Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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