SQLServerCentral » Latest topics
Error moving log.ldf
Hi all,
Tried moving log.ldf to another drive but hit error. Script and error as below...
ALTER DATABASE dbName set offline
ALTER DATABASE dbName
MODIFY FILE (NAME='dbName_log',FILENAME='L:\MSSQL\Data\dbName_log.ldf')
Tried moving log.ldf to another drive but hit error. Script and error as below...
ALTER DATABASE dbName set offline
ALTER DATABASE dbName
MODIFY FILE (NAME='dbName_log',FILENAME='L:\MSSQL\Data\dbName_log.ldf')
No comments:
Post a Comment