TITLE: Microsoft SQL Server Management Studio Express

Question

Post reply

TITLE: Microsoft SQL Server Management Studio Express

doca

SSC Enthusiast

Points: 149
More actions
March 5, 2009 at 5:19 am

#207226

Hi,
Im takin error when i restore my .bak file to my database it becomes
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'PERFECTPC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
How can i resolve this ? Is there any idea?
thanx

Viewing 9 posts - 1 through 8 (of 8 total)

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

steveb. SSC-Forever Points: 46733 More actions · Answer 1

Check your error logs there will be a more descriptive error message in there

Dugi SSCoach Points: 17998 More actions · Answer 2

doca (3/5/2009)
Hi,
Im takin error when i restore my .bak file to my database it becomes
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Restore failed for Server 'PERFECTPC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
How can i resolve this ? Is there any idea?
thanx

This .bak file is the backup from your SQL Express or is coming from other SQL versions !?

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

doca SSC Enthusiast Points: 149 More actions · Answer 3

i get this error

System.Data.SqlClient.SqlError: The operating system returned the error '5' while attempting 'RestoreContainer::ValidateTargetForCreation' on '(Microsoft.SqlServer.Express.Smo)

bak is comin another computer same version

Dugi SSCoach Points: 17998 More actions · Answer 4

...and if you have again the question about SQL Server Express you can start thread here

http://www.sqlservercentral.com/Forums/Forum324-1.aspx

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Please read through the error logs. There should be a more descriptive explanation to the error than what you have currently posted. Based solely on that error message, I have no idea why it may have failed.

doca SSC Enthusiast Points: 149 More actions · Answer 6

doca

SSC Enthusiast

Points: 149

March 5, 2009 at 6:04 am

#953955

ok thanx

Dugi SSCoach Points: 17998 More actions · Answer 7

doca (3/5/2009)
i get this error
System.Data.SqlClient.SqlError: The operating system returned the error '5' while attempting 'RestoreContainer::ValidateTargetForCreation' on '(Microsoft.SqlServer.Express.Smo)
bak is comin another computer same version

It seems that the account used to restore the database doesn't have privileges to write the files on specified path where you are attempting to restore DB! Check the user if can write to that location!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

Dugi (3/5/2009)
doca (3/5/2009)
i get this error
System.Data.SqlClient.SqlError: The operating system returned the error '5' while attempting 'RestoreContainer::ValidateTargetForCreation' on '(Microsoft.SqlServer.Express.Smo)
bak is comin another computer same version
It seems that the account used to restore the database doesn't have privileges to write the files on specified path where you are attempting to restore DB! Check the user if can write to that location!

Looks like the OP was posting additional info as I was writing my reply. I have to agree with Dugi at this point unless the OP is able to find additional information beyond what has already been provided.