asked
Not able to access the modellog file location.Sql services are not cameup
when i was moving model db, unfortunately I gave a wrong path in Alter command. I stoped the sql service from configuration manager then I tried to move the file to new location.New location is not existed. but sql service is not coming up. I tried placing the file in old location itself.But not able to start service. Can someone please help how to resolve this issue. Bootstrap file back is available since I install sql server Error msg I found in errorlog is: > Error: 17207, Severity: 16, State: 1. 2011-09-19 10:12:22.84 spid52 FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'F:\\Sql server insta files\\MSSQL10\_50.MSSQLSERVER\_IN1\\MSSQL\\DATA\\modelnewlocation\\modellog'. Diagnose and correct the operating system error, and retry the operation. I am assigned this new task.Please help
Have you tried to move the files to the location specified in the error message? `F:\Sql server insta files\MSSQL10_50.MSSQLSERVER_IN1\MSSQLDATA\modelnewlocationmodellog`
Yes ...I am able to move the files modellog.ldf to location 'F:\\Sql server insta files\\MSSQL10_50.MSSQLSERVER_IN1\\MSSQLDATA\\modelnewlocation\\' to make it clear file name: modellog.ldf old location: F:\\Sql server insta files\\MSSQL10_50.MSSQLSERVER_IN1\\MSSQL\\DATA\\modellog.ldf new locatin F:\\Sql server insta files\\MSSQL10_50.MSSQLSERVER_IN1\\MSSQL\\DATA\\modelnewlocation\\modellog.ldf but it seems ,in Alter command I havent specified the full path means instead of F:\\Sql server insta files\\MSSQL10_50.MSSQLSERVER_IN1\\MSSQL\\DATA\\modelnewlocation\\modellog.ldf I specified F:\\Sql server insta files\\MSSQL10_50.MSSQLSERVER_IN1\\MSSQL\\DATA\\modelnewlocation\\modellog I haven't mentioned the .ldf while exucuting alter command, but folder and files are available and I am able to move the file to new location from old location
What happens if you rename the file and remove .ldf as it seems like you have removed the file extension.
Take a look at this thread at microsoft, it may help you: [
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/146736a6-eb40-4743-ba5b-2e09b53883aa/][1] [1]:
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/146736a6-eb40-4743-ba5b-2e09b53883aa/
