May 24, 2012 at 3:05 pm
Hi, I moved msdb as it was taking up all of the C: drive. I followed these instructions (below) and all seemed to go well. When I restarted the services and attempted to log back in to the management studio i got a 4064 error. I managed to gain access using localhost to connect to the master db and then tried to alter login to set master as the default but it says I don't have permission. I am using the a local Windows account with local admin rights as I don't have the sa password. Any ideas???
SELECT
ALTER DATABASE MSDB
MODIFY FILE
(
NAME = MSDBData,
FILENAME= 'e:\sql_data\MSDBData.mdf'
)
GO
ALTER DATABASE MSDB
MODIFY FILE
(
NAME = MSDBLog,
FILENAME= 'e:\sql_data\MSDBLog.mdf'
)
GO
May 24, 2012 at 4:27 pm
I believe it's solved. I had to start the instance in single user mode and then reissue the commands to point msdb and log to the new location of the files. Then restarted services in normal mode and msdb was accessible again.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply