We help IT Professionals succeed at work.

SQL 2005 Backup

Starquest321
Starquest321 asked
on
Medium Priority
264 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?
Comment
Watch Question

Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
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
                                          /\

Author

Commented:
Thanks.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.