So this time I created a backup from the same server and compared the permissions of a file it creates vs what I'm trying to restore from. So I see 2 users are not in my .bak files so I add the same exact ones as in the other file and when I attempt to
restore the backup I get this error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'SIMPLYEMAIL'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
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\MSSQL10_50.WOMBOCOMBO\MSSQL\DATA\my-file.mdf'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
This is really frustrating, I've even gone as far as uninstall reinstalling.
Robert Black...
Member
31 Points
15 Posts
Re: backing up and restoring
Apr 23, 2012 03:46 PM|LINK
Still unable to restore a backup. This time I tried creating the backup without checking the box that said full copy.
When I try to restore from file I get a slightly different error this time:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.WOMBOCOMBO\MSSQL\Backup\MY_FILE.bak'. Operating system error 5(Access is denied.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I'm trying to restore from
C:\Program Files\Microsoft SQL Server\MSSQL10_50.WOMBOCOMBO\MSSQL\Backup
So this time I created a backup from the same server and compared the permissions of a file it creates vs what I'm trying to restore from. So I see 2 users are not in my .bak files so I add the same exact ones as in the other file and when I attempt to restore the backup I get this error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'SIMPLYEMAIL'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
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\MSSQL10_50.WOMBOCOMBO\MSSQL\DATA\my-file.mdf'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
This is really frustrating, I've even gone as far as uninstall reinstalling.