Solved

SQL 2005 Backup

Posted on 2006-10-20
3
199 Views
Last Modified: 2008-02-01
Does SQL 2005 provide a native backup solution? What are some of the best practices? Also does Veritas 10.1D provide backup for SQL 2005 using the 2000 license?
0
Comment
Question by:Starquest321
3 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 500 total points
ID: 17773248
SQL Agent and the maintenance plans are the native backup solutions for SQL 2005.

Best practices? Depends on your requirements and environment.
1.If you have heavy transactional throuput you should be backing up your transaction logs very frequently (every x minutes to hours).
2. What kind of rollback/recovery plan do you need? minutes, hours, days, and to what detail level.
3. Store backed up data off site (you can backup to disk, tape or whatever, as long as your backups are taken off site - whether this is via a WAN or courier).
There are many more - again, depends on your requirements.

Don't know Veritas, so I can't help you there.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17773810
about  licensing please contact Veritas- it depends to your company contract with Veritas
probably you need new license
...
But FYI:
 Backup Exec 10.1/d with HOTFIX 6 support SQL SERVER 2005
                                          /\
0
 

Author Comment

by:Starquest321
ID: 17782057
Thanks.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 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

16 Experts available now in Live!

Get 1:1 Help Now