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.
| 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 1Unable 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 |
 |
|
|
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 ? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-10 : 03:31:14
|
| Read write modify in the target Dir |
|
|
|
|
|
|
Error On Modify file command