SQL Server Performance

Make a database suspect for testing

Discussion in 'General DBA Questions' started by Trev256, Dec 1, 2009.

  1. Trev256 New Member

    Does anyone know how I can make a test database 'suspect' so I can test if my monitoring tool will generate an alert for this?
    Many Thanks
  2. Luis Martin Moderator

    As far I know there is no easy way to do that (I'm talking about something like power off).
    But, suppose you have one filegroup with this name:
    data01.mdf
    if you stop sql service and rename to data02.mdf (or ndf ) and restart sql service, I bet you will get what you want.

Share This Page