Sql Server Restore failed ‘The operating system returned the error (error not found)’ while attempting restore
Had this error today trying to restore an existing db from .bak. Looks like something to do with file / user permissions.
Seems the workaround is to run the service under ‘local system account’ (making this change will require a restart of the service).
- Go to services
- Find your sql service e.g. Sql Server (SQL EXPRESS)
- Right-click and select properties
- Select ‘Log on’ tab
- Under ‘Log on as’ make sure ‘Local System Account’ is selected.
- Restart Sql Server service
Wednesday Jul 28th
