April 4, 2011 at 8:16 am
I made a really n00b error on my SQL Server 2008 R2 installation. Instead of referring to the proper documentation I assumed moving the msdb/model databases required the same process that it did in SQL Server 2000/2005. I detached the model database while SQL was started with -c -f -T3608 and now SQL Server keeps shutting down saying
Error: 913, Severity: 16, State: 8.
Could not find database ID 3.
Can I recover without a backup of my master database or am I going to have to re-install?
John
April 4, 2011 at 8:26 am
Ok, so I rebuilt the system databases and it seems to have worked. Luckily this was a fresh install and there wasn't much configuration to redo.
April 4, 2011 at 8:27 am
John
Those are valid startup options in SQL Server 2008 R2. You should be able to start SQL Server again using those options and then attach msdb. Do you have more than one instance on your computer, and if so, are you sure you're attempting to start the right one?
John
April 20, 2011 at 1:50 am
JohnnyDBA (4/4/2011)
Ok, so I rebuilt the system databases and it seems to have worked. Luckily this was a fresh install and there wasn't much configuration to redo.
You have taken the extreme step and fortunately this was a fresh install. I have had few oppurtunities for migrating master and other system databases for different reasons and I lesson that I learnt was 'Never Detach System Databases'
If you need to change the location of say MSDB,then do the following:
1) Run Alter database command to specify the new location
2) you will receive a message like 'The changes have been done in catalogs. The new path will be used next time the database is started. ( not exact message but very similar. I am writing it from memory:-))
3) Stop the services
4) move the files to the new location
5) Start the services again.
Detach and attach method is something, i do not wish to use when dealing with system databases. I am sure few experts here will agree.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply