[ADSM-L] Snapshot Image Backup and SQL Databases
2008-05-07 05:35:25
Hi
TSM server v5.4.0
SQL Server 2005 running on Windows 2003
Hi
A have a query regarding Snapshot image backups and SQL databases.
I want to backup a 2tb drive which includes the SQL Server Databases. I
have installed LVSA and the online image backups work fine, taking 7 hrs
to backup and about 10 hrs to restore.
Our DBA's are concerned about the consistency of the SQL databases after
a restore is performed and have asked that i run a TDP backup prior to
the LVSA backup. The have concerns that SQL database pointers may not be
consistent if the databases(s) are doing a checkpoint at the tme that
the LVSA image is performed. In the event of recovery, the DBA's have
asked that i restore the LVSA and then restore the TDP backup
afterwards.
Any thoughts on this? Should the LVSA image restore the SQL databases in
a consistent manner?
Thanks
Jeff
****************************************************************************
Woolworths plc
Registered Office: 242 Marylebone Road, London NW1 6JL
Registered in England, Number 104206
This e-mail is only intended for the person(s) to whom it is addressed and
may contain confidential information. Unless stated to the contrary, any
opinions or comments are personal to the writer and do not represent the
official view of the company. If you have received this e-mail in error,
please notify us immediately by reply e-mail and then delete this message
from your system Please do not copy it or use it for any purposes, or
disclose its contents to any other person. Thank you for your co-operation.
****************************************************************************
------------------------------------------------------------------------------------
Email scanned for viruses and unwanted content by emailsystems
Information regarding this service can be found at www.emailsystems.com
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] Snapshot Image Backup and SQL Databases,
Jeff White <=
|
|
|