Need comparison details between Veritas Agent for MS SQL Server and SQL litepeed

Question

Need comparison details between Veritas Agent for MS SQL Server and SQL litepeed

sntiwary

Hall of Fame

Points: 3475
More actions
January 8, 2007 at 10:47 pm

#115856

Does anyone have comparison details of Veritas Agent for MS SQL Server and SQL litepeed ? I am looking mainly on compression level. Does veritas Agent for MS SQL Server shrink SQL database backup file like SQL litespeed?
Any information on this will be very helpful
thanks in adavance.
-SNT
January 11, 2007 at 8:00 am

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

I don't think both are same and I never used Veritas for sql server. Based my readings both software work differently and they has their own pros and cons..

You can go to veritas website and Litespeed (quest) website and get the info for complete comparision...

Then folloiwng comment is from veritas:

Ensure business-critical 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 2000 users granular protection on 32 and 64-bit systems down to the individual database or filegroup. Execute differential backups as well as Transaction Log backups with automatic truncation. Restore with one-pass recovery of the last full and any subsequent backup as a single restore job or perform "rollback restores", enabling a database to be recovered to a specific moment in time, rather than a specific restore point based on the last backup job. Multi-pipe and Virtual Device Interface (VDI) support gives users the most dependable and fastest method available for complete SQL Server protection.

MohammedU
Microsoft SQL Server MVP

Lowell SSC Guru Points: 323518 More actions · Answer 2

as I understand it, SQL Lite speed uses the updated SQL Server API's to create a standard SQL Server backup, abiet much faster, because the TSQL/Enterprise Manager backup commands use an older, slower API for backwards compatibility.

It's been a while since I used Veritas, because you had to purchase a separate extra SQL module, but as i remember it it took a backup of the ,MDF and .LDF files and saved them in it's own backup file for restoratino from within Veritas. the extra module was so that it could get the mdf's while they were open/in use.

HTH

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!