All geek questions in one place

Error restoring database?

TITLE: Microsoft SQL Server Management Studio Express

Recovery error for server WIN-4TNI5VVBQ0P \ SQLEXPRESS. (Microsoft.SqlServer.Express.Smo)

For help, click http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkIdid

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Directory search for the file "D: \ Orail Solution \ Pharmacy_New_Work \ PharmaDB.mdf" failed with operating system error 3 (the system cannot find the path specified). (Microsoft.SqlServer.Express.Smo)

For help, click http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

BUTTONS:

Ok

this is an error that appears to me when I restore a database in SQL Express version 2005

+3
source share
2 answers

The error you see indicates that it cannot find the path to the directory in which the database will be restored. He wants to put the .mdf database file in D:\Orail Solution\Pharmacy_New_Work.

You need to make sure that this path exists, and that there is sufficient permission for recovery to write to the path.

/ , , , , . .

+5

Source: https://habr.com/ru/post/1773728/

More articles:


All Articles