Hi Colin,

this statement scares me (as a DBA) :

>> So, what you are in effect saying is that my backups might be totally
>> useless because I might not be able to restore them even though the
>> backup worked correctly...

surely you test your backups to make sure that they are readable ? I'd hate
to think of anyone in a situation where they needed to restore a database
(of any flavour, ok, not SQL Server !) only to find that their entire stock
of backup tapes/disks/cds/etc is useless. I've seen and heard too many
stories where that sort of thing happens.

Always test a backup file to make sure it can be used to restore a database.

On the other hand, when I do my backups, I do a gbak and I do a OS file copy
as well. Works for me.

Cheers,
Norm.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

This email is intended only for the use of the addressees named above and may be confidential or legally privileged. If you are not an addressee you must not read it and must not use any information contained in it, nor copy it, nor inform any person other than Lynx Financial Systems or the addressees of its existence or contents. If you have received this email and are not a named addressee, please delete it and notify the Lynx Financial Systems IT Department on 0113 2892990.