Backup Strategy

what would be the best backup strategy like Full Backup every week,
differential every day and log backup every after 15 mins.
Any guidance ?
Hi,
You strategy looks very good. But I recommend you to perform a FULL database
backup incase your database is not really huge.
This will help you to do a fast recovery.
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:DAA42EBD-7944-4CCC-9769-C9FCD419E9BC@.microsoft.com...
> what would be the best backup strategy like Full Backup every week,
> differential every day and log backup every after 15 mins.
> Any guidance ?
>
|||There are some great resources out there to learn SQL Server that can give
you a lot more information than a news group post can. And in most cases is
less work. For instance if you haven't read "Inside SQL Server 2000" by
Kalen Delaney then you should. BooksOnLine has a tremendous wealth of
information about most of the questions you have asked over the last few
days. I recommend you browse though it as well. You will find out things
about SQL Server you might never have thought about otherwise. There are
many more good books out there in specific areas as well. These links are
also must reads:
http://www.google.com/search?hl=en&l...microsoft.com+
Google Search MS KB
http://www.aspfaq.com/
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Index Defrag
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
Operations Guide
Andrew J. Kelly SQL MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:DAA42EBD-7944-4CCC-9769-C9FCD419E9BC@.microsoft.com...
> what would be the best backup strategy like Full Backup every week,
> differential every day and log backup every after 15 mins.
> Any guidance ?
>
|||Hari, I am agree on that but how can we do point in time recovery if we take
full bakcup ?
Waiting for your reply
Thanks
"Hari Prasad" wrote:

> Hi,
> You strategy looks very good. But I recommend you to perform a FULL database
> backup incase your database is not really huge.
> This will help you to do a fast recovery.
> Thanks
> Hari
> SQL Server MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:DAA42EBD-7944-4CCC-9769-C9FCD419E9BC@.microsoft.com...
>
>
|||Hi
As long as you backup the Transaction Log and Full Dumps, you can do point
in time recovery.
A full backup doe not clear the transaction log, only a transaction log dump
does, During a full backup, the current log entries are copied into the db
dump.
If you do a daily full backup, with logs every 15 minutes, all you need to
restore is the full backup for the day, plus any logs up to the time you
want to do your recovery.
If you do a full backup on Sunday, logs every 15 minutes and a differential
every day, and you need to restore on Friday, you need the Sunday backup.,
the differential from Thursday and all the transaction logs after the
Thursday differential to the point in time. A Lot more work
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:96C53809-F429-4F5C-BC51-E9562A617ED6@.microsoft.com...[vbcol=seagreen]
> Hari, I am agree on that but how can we do point in time recovery if we
> take
> full bakcup ?
> Waiting for your reply
> Thanks
>
> "Hari Prasad" wrote:
|||Point in time recovery typically requires transaction log backups unless
your point in time is as of the last full backup (sort of).
Some additional points to note when planning your backup strategy:
1. How much down time are you willing to deal with? Restore will take time
regardless of what strategy you employ.
2. What is the rate of change in your database? This impacts your backup
startegy (how often should differential backup be run vs. transaction log)
and restore time.
3. How much data can you afford to lose? This impacts the frequency of you
transaction log backups and/or force you to think of other ways to protect
your database beyond backup.
Finally, and this is critical, please do test restoring your backups
regularly. You do not have a backup unless you have verified that you can
restore to the state you expected.
joe.
PS. I hope you're backing up to disk (then tape as secondary).
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:96C53809-F429-4F5C-BC51-E9562A617ED6@.microsoft.com...[vbcol=seagreen]
> Hari, I am agree on that but how can we do point in time recovery if we
> take
> full bakcup ?
> Waiting for your reply
> Thanks
>
> "Hari Prasad" wrote: