March 29, 2010 at 1:47 am
Hello,
I’m having a problem when I try to move my system databases. I have a server where SQL is installed on the C:\ drive, so this is where the systemdatabases are situated. I want to move the databases to the E:\ drive on the same server, and the log files to D:\.
To do this I’m running the following command (this example is for the tempdb):
USE master;
GO
alter database tempdb MODIFY FILE (NAME = tempdev,FILENAME='NEW PATH');
GO
alter database tempdb MODIFY FILE (NAME = templog,FILENAME='NEW PATH');
GO
The command completes successfully with no error messages. But when I restart the SQL server to make the change apply to the server It won’t start, and I get the following error messages in the event viewer.
Eventid: 17207
FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA'. Diagnose and correct the operating system error, and retry the operation.
Eventid:5123
FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA'. Diagnose and correct the operating system error, and retry the operation.
I’ve tried to run the SQL server with both the local system account as with a domain admin account with the same result. It seems that I’m missing one step.
Thanks in advance for all help I can get.
March 29, 2010 at 1:51 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply