Backups

How do you backup a SQL database so the logs are commited
to the database file? Will a backup using Veritas Backup
Exec do it for us or do I need to use SQL to backup the
product?
Thanks,
ScottAll inactive (not-currently running) transactions will be included in your
db backup, a db backup does not back up the actual log though. Your log will
still have the same footprint size and used space size.
Ray Higdon MCSE, MCDBA, CCNA
--
"spt" <anonymous@.discussions.microsoft.com> wrote in message
news:bd8b01c40c17$295146b0$a601280a@.phx.gbl...
> How do you backup a SQL database so the logs are commited
> to the database file? Will a backup using Veritas Backup
> Exec do it for us or do I need to use SQL to backup the
> product?
> Thanks,
> Scott|||I would like to get some more information before I can address your
concerns.
Any third party product, will use the SQL APIs for Backup. So the first
thing would be to do a GAP analysis of what SQL Server Backup can provide
and what your specific requirements are. For this, I would recommend that
you go through the BooksOnline Backup section that provides all the
information that you would ever need about SQL Server Backup. I would also
suggest that a Backup Plan is of now use without a Disaster Recovery plan.
For that, plese visit the following links :
http://support.microsoft.com/defaul...kb;en-us;169039
http://support.microsoft.com/defaul...kb;en-us;307775
Once you are done with it, you will get a fair idea of what you can achieve
with SQL Backup and what are the GAP areas for which you might want to use
a third party product.
Please let me know if I can be of any further assistance.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.