May 17, 2012 at 6:48 am
Hi there,
SQL 2008 install. I have a default instance and a named instance.
I wanted to move the master, model, msdb and tempdb. As well as the Reporting Services dbs.
I ran the following script for all the dbs I wanted to move -
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path\os_file_name' )
I then stopped all the services and physically moved the actual database files and log files.
They have been moved to the E:\ for data and L:\ for the logs.
I only moved the instance1 databases.
Now the default instance services all start up fine. But the named instances ones - the ones I have moved do not.
I get the following error -
Windows could not start the SQL Server (INSTANCE1) on Local Computer. For more information, review the Systems Event Log. If this is a non-Microsoft service contact the service vedor, and refer to service-specific error code 17113.
Any idea guys? Thanks
May 17, 2012 at 6:51 am
did you issue ALTER DATABASE .... MODIFY FILE for the master database?
May 17, 2012 at 6:52 am
Hi there,
Yes I used the same TSQL on all the DBs.
May 17, 2012 at 6:54 am
That will be the issue, you shouldnt issue ALTER DATABASE master MODIFY FILE as the MDF and LDF locations are also stored in the SQL Server Configuration Manger which is probably where the conflicts are coming from as the master database isnt in the location where the service is trying to load the database from
Follow this link http://msdn.microsoft.com/en-us/library/ms345408.aspx to change the config manage to point to the new master location
May 17, 2012 at 6:58 am
Ahhhh. That's me not reading the step by step guide properly.
Thanks
May 17, 2012 at 9:43 am
The Master location is sent to SQL Server as a startup parameter for the service. In the Configuration manager (or services, don't use that), you can see the parameters. I believe the ALTER DATABASE MASTER, changes these as well.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply