Hi All,
Here is some feedback of the backup software that I am using:
My database size is about 1TB. For me a good backup is a matter of life and death situation. I decided after several months of testing to use the LightSpeed from the Quest company found at:
http://www.quest.com/litespeed-for-sql-server. I tried also RedGate and was not impressed with that software. It does not have the flexibility LightSpeed provides.
LightSpeed is being used by MicroSoft for their own database, I actually spoke with one of their DBAs and while I was telling him that I am looking for a backup software he told me about it. Quest provides 24/7 tech support and one time on Saturday I called them when the Trial version expired and needed to restore a table. They dispatched a tech guy from his home that called me and took care of the problem.
I got the enterprise version since It can restore one table at the time as well, so no need to restore the whole database if one table is needed. It has many stored procedures that I can run via the ms sql 2008 and see the status of the restore or backup.
They also provided with a demo to me and Edhy about what you can do with their backup software. Because of the economy situation they were able to provide an aggressive discount. If you need to get some info here is the sales rep that helped me to nail the deal:
Kyle M. Drehwing
SQL Server National Account Manager
Quest Software
(w) 732-409-5131 | (c) 201-240-6316 | (f) 949-790-2109
Regards,
Doron