database backup using Veritas

Hi
My client wants to use veritas tape back in SQL Server 2000 Standalone and
cluster environment.
Can anyone tell disadvantages/practical issuse with veritas backup?
thanks
KalyanHi Kalyan
I am using Veritas netbackup for SQL server on SQl server 2000 and has no
issues with it. It is easy to use but I would prefer SQL*LITE
which provide much better functionality than veritas. The latest version
support tape backups too.
Tks
Mangesh
"Kalyan" wrote:

> Hi
> My client wants to use veritas tape back in SQL Server 2000 Standalone and
> cluster environment.
> Can anyone tell disadvantages/practical issuse with veritas backup?
> thanks
> Kalyan
>|||Personally from what I have experienced with VERITAS using backup tapes you
are better off using LightSpeed for backing up your SQL server because it
compresses the databases backup sizes by about 60% of what the normal backup
size would be on the hard drive. Also tape backups are not the most reliabl
e
form of backup method in my opinon. I have used backup software and rotated
on removalable storage drives so that you can have a copy of database data
stored off location in case of a major disaster you have company livelyhood
in another location at all times.
Hope this helps. Below is the VERITAS information:
---
VERITAS Backup Exec 10 for Windows Small Business Server provides
exceptional value at a single price point. Best of all, the products are eas
y
to install and manage!
KEY BENEFITS
Complete data protection for Microsoft Windows Small Business Server 2000
and 2003
Easy to use, deploy and manage through user-friendly wizards
Low-cost, highly adaptable solution supporting backup and restore from disk
and tape devices
Intelligent Disaster Recovery reduces downtime for the local server and all
protected client systems at no extra cost
Fast backup and restore of Exchange Server, SQL Server, and SharePoint
Services
Continuous backup protection option for desktops and laptops
PRODUCT HIGHLIGHTS
ENHANCED! Cost Effective Complete Data Protection Solution – Backup Exec
software’s Small Business Server Edition provides complete data protection
for Microsoft Windows Small Business Server 2000 and 2003 in one totally
comprehensive suite. Core functionality includes database agent technology
for protecting Microsoft Exchange Server, SQL Server, and SharePoint
Services, Intelligent Disaster Recovery, and single tape drive autoloader
support.
ENHANCED! Ease of Use – Enhanced install wizard helps ensure fast and
successful installations. Web-based administration console, new policy
wizard, and the new Backup Exec assistant, enable easy management and improv
e
the overall customer experience.
ENHANCED! Disaster Recovery for the Entire Environment – Provides recovery
solution for media server and all systems backed up by the Backup Exec serve
r
at no extra cost, eliminating the need to first reload the entire operating
system of crashed servers. Includes the ability to create system specific
recovery media for protected systems even AFTER a system crashes.
ENHANCED! Desktop and Laptop Option – Provides continuous disk-based
protection and synchronization for users that are in the office or on the
road. Designed to automatically copy user data to existing network shares or
storage, it enables quick recovery of data by the administrator or the user
for optimum efficiency. The new push-install functionality from within Backu
p
Exec streamlines deployment, and user-specific backup reports improve data
and service level visibility.
Support for Microsoft Volume Shadow Copy Services Writer – Backup Exec
Software’s Small Business Server Edition supports Microsoft’s VSS writer
s
simplifying the protection and recovery of Exchange and SharePoint Services
Faster, Flexible Backup and Restore Management of Online Exchange Servers
Single Instance Storage (SIS) of email message attachments, incremental or
differential mailbox backups and individual public folder restore provide
granularity and deliver faster backup and recovery of Exchange servers. The
agent also empowers administrators to perform individual mailbox backup with
selective restore, down to an individual message.
INCLUDED AGENTS AND OPTIONS
ENHANCED! Intelligent Disaster Recovery Option Saves recovery time by
automating the traditional manual, error prone process. The Intelligent
Disaster Recovery Option automates server recovery, reducing the time to
recovery and gets you back into business fast. Implement a server recovery
solution for both local and remote Windows servers, eliminating the need to
first reload the entire operating system of crashed servers. Using either
diskette-based, CD-R/CD-RW or bootable tape, the Intelligent Disaster
Recovery Option will quickly recover downed servers and workstations enablin
g
restores from the last complete backup set including full, differential,
incremental, and working set backups. The Intelligent Disaster Recovery
Option integrates directly with Microsoft’s Automated System Recovery (ASR
)
functionality in Windows Server 2003 and Windows XP to provide complete
disaster recovery on Windows servers. With Offline Protection functionality,
even when computer crashes before administrators create disaster recovery
media, IDR can still recover the computer using a full backup that includes
information needed to restore the system made prior to the crash.
ENHANCED! Agent for Microsoft Exchange Server Fast, flexible technology to
protect vital Exchange Server 5.5, 2000 and 2003 data while the application
is online. This agent provides full, incremental, or differential backup and
restores of embedded objects, attributes, and all Outlook components. Restor
e
can automatically mount the database upon completion of backups, which
ensures the valid database is brought back online quickly. Using the Single
Instance Storage (SIS) feature eliminates backup of duplicate information by
storing only the first instance of attachments distributed to multiple
mailboxes. For Microsoft Windows Exchange 2003 Server support, the mailbox o
r
message level restores from a full traditional backup does not require
installation of a separate Exchange 2003 server. When running on Microsoft
Windows Server 2003, the Backup Exec Agent for Exchange Server has added
support for Microsoft Exchange Server 2003 Volume Snapshot (VSS) technology
enabling the user to select either the VERITAS or the Microsoft proprietary
frozen image technology for protecting open files. The agent provides the
ability to perform consistency checks before backup when using Microsoft
Volume Shadow Copy Service.
ENHANCED! Agent for Microsoft SQL Server Ensures business- ritical databases
and e-business data are protected in the event of application or
hardware-based corruption or loss. This agent provides SQL Server 7.0 and SQ
L
Server 2000 users granular protection down to the individual database or fil
e
group. Execute differential backups as well as Transaction Log backups with
automatic truncation. Restore with one-pass recovery of the last full and an
y
subsequent backup as a single restore job or perform “rollback restores”
,
enabling a database to be recovered to a specific moment in time, rather tha
n
a specific restore point based on the last backup job. Virtual Device
Interface (VDI) support gives users the most dependable and fastest method
available for complete SQL Server protection. The agent supports Microsoft
Volume Shadow Copy Service (VSS) snapshot technology to create point-in-time
,
recovery consistent snapshots of SQL Server 2000 on Windows Server 2003.
Consistency checks can be performed before backup when using Microsoft VSS
snapshot provider.
ADDITIONAL SMALL BUSINESS SERVER AGENTS AND OPTIONS SOLD SEPARATELY ENHANCED
!
Desktop and Laptop Option Most businesses rely on users to manually copy
business critical data to a server. When users do not comply, the majority o
f
business-critical information residing on employee workstations, desktop and
laptop does not get protected. The Desktop and Laptop Option delivers
continuous data protection to desktops and laptops whether in the office or
on the road. Not only improving data protection and efficiency, this option
enables users to restore their own files, and maintains synchronization
between multiple desktops and laptops so the most up-to-date file versions
are available on all of a user’s computers. Because the Desktop and Laptop
Option does not require a dedicated stand alone server as competing products
do, it easily integrates into existing IT infrastructure and policies,
helping lower the total cost of ownership. The new push-install functionalit
y
from within Backup Exec centralizes deployment. This version also adds
Outlook 2003 support, reporting and console access control.
Library Expansion Option
Scale the media storage system by leveraging additional drives within
multi-drive tape or optical autoloader/library storage systems. This option
leverages Backup Exec’s Advanced Device and Media Management (ADAMM)
technology to provide extensive configuration and management capabilities to
include “lights-out” backup and restore operations, bar-code reader and
portal support for both SCSI and fibre-attached devices. Users can partition
slots within libraries to target backup jobs to a specific slot.
ENHANCED! Advanced Open File Option
Helps ensure that files on local or remote servers are protected even while
in use. The VERITAS Backup Exec? Advanced Open File Option handles open fi
les
at the volume level and is seamlessly integrated into Backup Exec software.
There is no need to know which files are open ahead of time; just set a
scheduled backup to use this option with a simple mouse click. It can backup
multiple volumes in one job while creating a snapshot of only one logical
volume at a time. After the logical volume is snapped and backed up, the
snapshot is deleted before the next logical volume is snapped. This feature
increases the ability to meet the minimum quiet time needed to complete a
snapshot. Advanced technology also provides the ability to detect and
leverage alternate frozen image technologies such as Microsoft Volume
Snapshot Service (VSS) on Windows Server 2003 or VERITAS Storage Foundation
for Windows FlashSnap? for increased application availability.
ENHANCED! Remote Agent Client Access License (CAL) for Windows Servers
Expand network-wide data protection and optimize data transfers for 32 and
64-bit remote Windows servers, including local Registry and System State
information. Exclusive Agent Accelerator technology maximizes backup and
recovery performance by providing source-level compression and distributed
processing at the client. The result is reduced network traffic and maximize
d
data throughput.
ADDITIONAL BACKUP EXEC FEATURES
Backup & Restore
Support for Microsoft Windows Small Business Server 2003 Standard Edition
Support for Microsoft Windows Small Business Server 2003 Premium Edition
Support for Microsoft Windows Small Business Server 2000
Single-step protection of Server and Exchange data
Individual Mail Message Restore
Single-pass recovery of SQL Server
One-Button Backup capability
Complete Workstation Protection and Recovery
Desktop & Laptop Data Protection Option
Remote System Management capabilities
Environment check utility for the proper system configuration
CA ARCserve Tape Read Capability
Report Generation
44 Backup reports
Other Features
Include/Exclude File Selection
Onscreen Progress and Status Indicators
User Configurable Alerts
Automatic Job Retry
Scheduled Job “Test Run”
Single Drive Library Support
100% Compatible with Microsoft Tape Format
Software Compression
Hardware Compression
Backup to Disk
Specified Backup NIC
SharePoint Services Support via Volume Shadow Copy Services “Writer”
Integration
"Kalyan" wrote:

> Hi
> My client wants to use veritas tape back in SQL Server 2000 Standalone and
> cluster environment.
> Can anyone tell disadvantages/practical issuse with veritas backup?
> thanks
> Kalyan
>