?
Solved

"Real Time" backups of SQL Server databases

Posted on 2011-09-21
5
Medium Priority
?
257 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 40

Assisted Solution

by:lcohan
lcohan earned 2000 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 2000 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 2000 total points
ID: 36580482
0
 
LVL 26

Author Closing Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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 a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Screencast - Getting to Know the Pipeline

830 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