troubleshooting Question

SQL Server 2008 R2 won't start

Avatar of Bodhi108
Bodhi108 asked on
Microsoft SQL ServerMicrosoft DevelopmentMicrosoft SQL Server 2008
2 Comments2 Solutions1955 ViewsLast Modified:
I put Service Pack 1 on SQL Server 2008 R2 and now I cannot start up SQL Server localhost.  The error I am getting is:

Cannot use file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\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.

I don't care about the existing mdf and ldf since I have a backup.  What do I need to do so I can start up SQL Server localhost?

Microsoft SQL Server Management Studio      10.50.2500.0
Microsoft Analysis Services Client Tools          10.50.2500.0
Microsoft Data Access Components (MDAC)    6.1.7601.17514
Microsoft MSXML                                            3.0 4.0 5.0 6.0
Microsoft Internet Explorer                            9.0.8112.16421
Microsoft .NET Framework                              2.0.50727.5420
Operating System                                            6.1.7601
Matt Bowler
Database Reliability Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros