Restoring log file to sector size 4096 from sectro size 512

• rsduddupudi

  SSC Veteran

  Points: 215

  More actions

  March 16, 2012 at 5:52 pm

  #270127

  I am getting the following error when I try to restore database to fusion IO drive.

  I am trying to restore from sql 2005 backup .

  I also took back with option blocksize = 4096 but still getting the same error..

  My server details are

  windows 2003 server

  sql server 2005 (64 bit)

  Can anyone please help me.

  Error Message:

  Msg 5178, Level 16, State 1, Line 1

  Cannot use file % because it was originally formatted with sector size 512 and is now on a volume with sector size 4096. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.