March 6, 2012 at 12:33 pm
using SQL 2005...
A database is using SAN storage. Backups are being done of all folders mapped to there server, including those from the SAN. NetBackup without the SQL Server agent is being used to make daily backups to disk. Can these backups be used for recovery, considering they are taken when the database is open, i.e., are they valid. Would greatly appreciate any info or reference you can provide. Thank you.
March 6, 2012 at 12:40 pm
I would not rely on those backups for recovery of any database. Most likely they will be in an inconsistent state and unusable.
You really need to use either SQL Servers native backup routines or a third party utility that properly backs up the SQL Server databases.
I prefer taking a disk to disk backup of the databases then backing up that backup file to other locations, whether disk or tape.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply