Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error On Modify file command

Author  Topic 

m.esteghamat
Starting Member

47 Posts

Posted - 2015-01-09 : 20:42:41
I tried to change a DB Log file path.
But After run this command and move physical file to new location , I got The error . (and sql server create a new log file in old path)
for your info :
- sql server account is : NT Service\MSSQLSERVER
- (File name and location path are right.)
please help.
thank you
--------------------------
Command : (After offline)
ALTER DATABASE ..._Log
MODIFY FILE ( NAME = ..._log, FILENAME = "NewPath...\..._log.ldf")
-----------------------
Error : (After online again)
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "..._log.ldf". Operating system error 5: "5(Access is denied.)".
File activation failure. The physical file name "..._log.ldf" may be incorrect.
New log file "OldPath..._log.ldf' was created.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-09 : 20:51:48
Looks like an access issue. Check the security settings on the target directory
Go to Top of Page

m.esteghamat
Starting Member

47 Posts

Posted - 2015-01-10 : 00:51:40
Dependings on The main service account (nt service\mssqlserver) , which access should I get to which account ?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-10 : 03:31:14
Read write modify in the target Dir
Go to Top of Page
   

- Advertisement -