creating database on compressed drive

• Shivrudra

  SSCrazy

  Points: 2799

  More actions

  January 22, 2010 at 1:32 am

  #218413

  Hi all

  is it possible to create the database on Compressed drive by SQL server 2008 ....

  Regards,
  Shivrudra W

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  January 22, 2010 at 1:52 am

  #1107154

  Yes it is possible.

  SQL Server 2008 has row/page compression option. You can utilize it.

  Compressed drive for SQL Server database is to be used only if you don't have any other option.

  Because it is synchronous operation and can slow down SQL Server.

• Shivrudra

  SSCrazy

  Points: 2799

  More actions

  January 22, 2010 at 2:03 am

  #1107160

  Thanks,

  can you please provide me the sample Example (Script) for same

  Regards,
  Shivrudra W

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  January 22, 2010 at 2:26 am

  #1107176

  row/page compression supports tables and indexes.

  Sample:

  CREATE TABLE T2

  (c1 int, c2 nvarchar(50) )

  WITH (DATA_COMPRESSION = PAGE);

  GO

  For more information please see BOL.