SQL Server Services won't start

Question

SQL Server Services won't start

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 1

I would force start sql server and try re-running the alter database statements with the correct path and filename I don't see why it wouldn't work.

hth

David

Jpotucek SSCoach Points: 18583 More actions · Answer 2

That's an awesome idea!!! I started SQL Server from a command prompt net start mssql$aml /f /t3608

I then opened a new query window and reran my statements:

ALTER DATABASE MSDB MODIFY FILE ( NAME = MSDBData , FILENAME= 'E:\MSSQL\AML\DataFiles\msdbdata.mdf' )

ALTER DATABASE MSDB MODIFY FILE ( NAME = MSDBLog , FILENAME = 'F:\MSSQL\AML\LogFiles\msdblog.ldf' )

ALTER DATABASE Model MODIFY FILE ( NAME = ModelDEV , FILENAME = 'E:\MSSQL\AML\DataFiles\model.mdf' )

ALTER DATABASE Model MODIFY FILE ( NAME = ModelLog , FILENAME = 'F:\MSSQL\AML\LogFiles\model.ldf' )

ALTER DATABASE TempDB MODIFY FILE ( NAME = TempDEV , FILENAME = 'G:\MSSQL\AML\TEMPDB\tempdev.mdf' )

ALTER DATABASE TempDB MODIFY FILE ( NAME = TempLOG , FILENAME = 'G:\MSSQL\AML\TEMPDB\templog.ldf' )

same errors 🙁 when I restart SQL Server

anything else I can do short of having the server rebuilt?

I REALLY don't want to ask to have the Server rebuilt

Jpotucek SSCoach Points: 18583 More actions · Answer 3

Thank you everyone who responded for all your help!!!

I force-started sql server and reran my alter database statements WITH the filenames (DUH!!!!!)

and I was able to start SQL Server!!!!!

Adam Haines SSC-Insane Points: 23217 More actions · Answer 4

I am glad everything worked out. As a piece of advice, before doing anything to the master database, back it up. The instance cannot run without this database.

My blog: http://jahaines.blogspot.com

EdVassie SSC Guru Points: 60472 More actions · Answer 5

If you want some scripts that will do these moves, try SQLServerFineBuild.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Jpotucek SSCoach Points: 18583 More actions · Answer 6

Thank you!! and by the way. I successfully moved my master and resouce databases and I then moved ALL the databases on the second box that I had to build without issue. Thanks for your help.. you guys are great!