Why the backup can't be restored? Thanks.

Question

Post reply

Why the backup can't be restored? Thanks.

halifaxdal

SSCoach

Points: 19741
More actions
August 8, 2011 at 7:43 am

#241432

I am trying to restore a database on server B which was backed up on server A, backup file has already been shipped to server B.
I got this error message, can anyone look at it for me please? Thank you very much.
(Note: server B has SQL 2005 Express installed, server A is SQL 2005, does this matter?)
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'TISMJPVV62\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&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\MSSQL.1\MSSQL\Roogle.MDF'. (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
------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

~~How big are the datafiles (not the backups, but the restored files)? Express can't go above 4GB in 2K5.~~

Does the serer have permissons to write in that folder?

halifaxdal SSCoach Points: 19741 More actions · Answer 2

Ninja's_RGR'us (8/8/2011)
~~How big are the datafiles (not the backups, but the restored files)? Express can't go above 4GB in 2K5.~~
Does the serer have permissons to write in that folder?

Thanks.

I figured it out: in Configuration manager, in the property of SQL Server Express, change the log on account to built-tin account: Local System, restart SQL then it works like a treat.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

halifaxdal (8/8/2011)
Ninja's_RGR'us (8/8/2011)
~~How big are the datafiles (not the backups, but the restored files)? Express can't go above 4GB in 2K5.~~
Does the serer have permissons to write in that folder?
Thanks.
I figured it out: in Configuration manager, in the property of SQL Server Express, change the log on account to built-tin account: Local System, restart SQL then it works like a treat.

Awesome, thanks for the feedback.