The SQL Server service won't start on my 2008 R2 system. Nothing has changed on the system, but this error is in the event log every time I try to start the service:
Cannot use file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.VIM_SQLEXP\MSSQL\DATA\mastlog.ldf' 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.
It is running on a SuperMicro server and it has 2 1TB drives setup as a raid 1 using the built-in raid adapter. There is an additional error at the same time, but it is about "master.mdf" in the same location.
I ran "chkdsk /r /f" and then rebooted the system and it never fully came backup. I can ping the system, but I can't access any shares, rdp, or login with psexec anymore. I'll have to make a trip to the site tomorrow to get a visual on it.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.