Ao tentar efetuar o restore do banco indicado na aula, usando o arquivo .BAK baixado na aula estou recebendo o seguinte erro:
===================================
Restore of database 'FONTES_DB' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
Program Location:
at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context) at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.Perform(ITaskExecutionContext context) at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector)
===================================
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\FONTES_DB.mdf'. (Microsoft.SqlServer.SmoExtended)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18118.0+((SSMS_Rel).190420-0019)&LinkId=20476
Program Location:
at Microsoft.SqlServer.Management.Smo.RestorePlan.Execute() at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)
Podem me indicar um solução? Dei uma googlada but não consegui resolver.
