When trying to restore a database backup you my across the following error "Restore failed for Server '...\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)". There are 4 ways of solving this problem. Check the one that is working for you.
1) Change the sql service to run as a local(not as a NetworkService). You can do that in services in the administrative tools.
2) Check the "Overwrite the existing database" in Option section.
3) Add new admin user with privileges to write in mssql folder.
4) If nothing solves the problem try selecting new paths for the generated mdf and ldf files of the restored DB.
0 коментара:
Публикуване на коментар