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
   

   Trev256, Dec 1, 2009

   #2
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.
   
   

   Luis Martin, Dec 2, 2009

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in