vendredi 31 juillet 2015

Not able to start sql server service after moving the data files to new location

I have moved the data files to new location but while moving I have given the wrong data file name. So it is throwing error

A file activation error occurred. The physical file name 'D:\Programfiles\Microsoft Sql server\MSSQL2008\Data\MSDBLog.ldf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

FCB::Open failed: Could not open file D:\Programfiles\Microsoft Sql server\MSSQL2008\Data\modellog.ldf for file number 2. OS error: 5(Access is denied.).

these were the errors I was getting after the data file movement.

Please suggest me what should be done to run the sql server service.

Aucun commentaire:

Enregistrer un commentaire