SQL Server 2012 install fails -sector size error

[raygg]

I'm an Oracle DBA very new to SQL Server. Am failing to install SSDB 2012 on Lenovo laptop w 4gb ram,750 gb HD (non-partitioned), running win7 pro sp1. During the installation I ran the installation as LenovoT61\Ray - and added that name during the install as a user administrator. That is my laptop logon and I also specified windows authentication. The only thing I did not do is start the install with the 'run as administrator ' option. Iam submitting this to the forum here but I WILL try the 'run as administrotor ' option for the install as well.

The error log has message
"2012-12-10 15:41:52.23 spid7s Error: 5178, Severity: 16, State: 1.
2012-12-10 15:41:52.23 spid7s Cannot use file 'C:\Program Files\Microsoft SQL Server\MSSQL11.CSDWH\MSSQL\DATA\master.mdf' because it was originally formatted with sector size 4096 and is now on a volume with sector size 3072. Move the file to a volume with a sector size that is the same as or smaller than the original sector size."

I have failed with this install several times and previously had the SSDB 2012 install working and removed it.

THe window popup error message window I get at te end of the install is 'Fatal error 0x80070643 during installation wait on the database recovery handle field '[I may have the wording slightly wrong on this but the error code is correct]

I ran the following in DOS and it shows the sector size is 4096 in the directory mentioned in the error message log above. I am confused and out of ideas as the errormessage sector info conflictswith thesector size as shown by the cmd utility - and I do not know ifthis is the cause of the installation failure..

C:\Program Files\Microsoft SQL Server\MSSQL11.CSDWH\MSSQL\DATA> FSUTIL FSINFO NTFSINFO c:
NTFS Volume Serial Number : 0x602cdeb92cde8a04
Version : 3.1
Number Sectors : 0x0000000057512fff
Total Clusters : 0x000000000aea25ff
Free Clusters : 0x000000000700719c
Total Reserved : 0x00000000000007c0
Bytes Per Sector : 512
Bytes Per Physical Sector : <Not Supported>
Bytes Per Cluster : 4096
Bytes Per FileRecord Segment : 1024
Clusters Per FileRecord Segment : 0
Mft Valid Data Length : 0x0000000018440000
Mft Start Lcn : 0x00000000000c0000
Mft2 Start Lcn : 0x0000000000000002
Mft Zone Start : 0x0000000002f56de0
Mft Zone End : 0x0000000002f63600
RM Identifier: B2C51BD6-7DAA-11E1-9C96-8D7D761FBAB9

 

[fredericofonseca]

Some of the errors I've seen related to this were due to Intel Rapid Storage Technology driver - if you have it try reinstalling it, even if it says it is up to date

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[raygg]

In attempting to download an updated Intel Rapid Storage Technology driver from the Lenovo support webpage,the doc with the drivers indicate the driver available is not a replacement for the driver I have on the laptop. Also -Properties of the drivers indicate the drivers are working properly.