Subject Re: Locking a database to cause a backup to fail
Author Adam
--- In, "Steve Harp" <steve@...> wrote:
> Hi Guys,
> Is there a way to lock a database to force a backup will fail?
> Why would anyone want to do this you ask? Well, my boss is trying to
> test an application and wants to see the response when a backup fails.
> Thanks,
> Steve

Lots of ways.

Add a not null field to a table with existing data and do not fill the
pre-existing records with values is the easiest guaranteed method I
have seen.

Playing around yourself with system tables is also pretty reliable, as
is connecting to a database before a restore is complete or switching
forced writes off and hard powering down during an operation.