江湖救急!如何恢复备份好的.bak文件
D:\数据库作业\LkMusicDB_LogBackup_2013-12-06_16-10-38.bak
bak 文件存这里
重装系统后,又重装了sqlserver2012, 空的sqlserver
回复后 出现这种错误
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LkMusicDB.mdf'. (Microsoft.SqlServer.SmoExtended)
[解决办法]
Access is denied
应该是sql server 对应的账号权限不够,没有修改这个文件的权限