make database read-only?

• John-238382

  Old Hand

  Points: 380

  More actions

  November 21, 2005 at 9:25 pm

  #110941

  How do I make database read-only, especially using 'alter database' statement?

  The closest I came (which doesn't work) is:

  ALTER DATABASE booka

  modify filegroup PRIMARY READONLY

  Thanks.

• philcart

  SSC-Forever

  Points: 47797

  More actions

  November 21, 2005 at 9:51 pm

  #605128

  From Books Online, the correct syntax to make the database read-only is,

  ALTER DATABASE booka SET READ_ONLY

  The command you're trying is setting the filegroup to be read-only.

   

  --------------------
  Colt 45 - the original point and click interface