March 4, 2013 at 6:16 pm
SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas how to correct without reinstalling?
Also Sql 2008 R2 will not start with trace -f -T3608 or single user mode -m. Need params to start SMS to move Model back.
Need resolution please.
March 4, 2013 at 8:53 pm
After the move and restarting the SQL Service as model db is not available or sql server is not able to find it it is not starting the service.
Check if you have the physical files at that location. How did you move by attach/deattach or Alter database command? If alter database command check the path , name etc are proper. Many time due to spelling typo and path mismatch I have faced this issue.
Generally 945 error is file not accessible check if SQL Service account have the sufiicient access to the folder you had moved the model database.
"More Green More Oxygen !! Plant a tree today"
March 4, 2013 at 9:02 pm
Tony Saucedo (3/4/2013)
SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas how to correct without reinstalling?Also Sql 2008 R2 will not start with trace -f -T3608 or single user mode -m. Need params to start SMS to move Model back.
Check the folder have enough permissions for the SQLserver service account.
Need resolution please.
March 4, 2013 at 9:48 pm
In addition to what Minaz threw out there, is the server Clustered? If so, verify that the location that the model db was moved to is on a resource that is accessible to SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 4, 2013 at 10:01 pm
Yes, the folder is actually the SQL Data on Drive D: where other Databases were.
It is not a cluster environment.
March 4, 2013 at 10:04 pm
baabhu (3/4/2013)
Tony Saucedo (3/4/2013)
SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas how to correct without reinstalling?Also Sql 2008 R2 will not start with trace -f -T3608 or single user mode -m. Need params to start SMS to move Model back.
Check the folder have enough permissions for the SQLserver service account.
Need resolution please.
Yes have permissions to the SQL Data folder on Drive D which has DBs that were being used.
Used the Alter command then move/copied the model.mdf and ldf to Drive D: SQLData & SQLLogs.
March 5, 2013 at 12:24 am
Tony Saucedo (3/4/2013)
SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas how to correct without reinstalling?Also Sql 2008 R2 will not start with trace -f -T3608 or single user mode -m. Need params to start SMS to move Model back.
Need resolution please.
Got it fixed.
Startup parameters had incorrect path. Registry did not get updated, had to manually update it the path for same Startup parameters in Service Adv. properties.
Model and TempDB are at their new location. Master will be moved later.
March 11, 2013 at 4:44 am
Best Practice advice is do not mode master, model or the resource database. There are no performance or data integrity reasons to move these databases, so all you are doing is adding risk to your installation. The fact that you had a problem shows one of the risks you can have.
Microsoft also has a poor track record in making SPs and CUs work when in particular master and the resource database are not in their default locations. This is another issue you risk having.
Many people also include msdb in the list of databases to leave in their default location, but others say this should depend on how much use you make of msdb. In any case, moving msdb has less inherent risks than moving master, model or the resource DB.
tempdb is different, with best practice advice being to locate it whre it performs best, and consider splitting it into multiple files if you have spacemap contention.
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
March 11, 2013 at 5:16 am
Model database is used by Tempdb during restart . and that could be the why sql server didnt get re-start
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply