April 18, 2008 at 1:50 pm
Can you restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition? Seems like you can't. I tried it and errors are produced. Any thoughts?
April 19, 2008 at 7:55 am
Hello,
Normally, there are 2 cases where a restore may go wrong :
- you restore towards an earlier version ( 2005 ==> 2000 )
- you restore towards a "smaller" version ( Entreprise ==> Express )
With Express edition towards Entreprise, you may have problems if the Express Edition is wit user instances enabled
You may have problems when you have not the log file and the primary file is Read-Only ( enable Read-Write and no more problems )
Have a nice day
April 21, 2008 at 5:59 am
pbyrum (4/18/2008)
Can you restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition? Seems like you can't. I tried it and errors are produced. Any thoughts?
Could you post the error??? I hope you have not changed the path for physical file..
Regards..Vidhya Sagar
SQL-Articles
April 21, 2008 at 11:14 am
Here is the error message:
Restore failed for Server 'pb003070\express'. (Micrsoft.SqlServer.Express.Smo)
System.Data.SQLClient.SQLError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetFor Creation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\lava ent.mdf'. (Micrsoft.SqlServer.Express.Smo)
April 22, 2008 at 6:12 am
Try to restore database so its files are not located in Program Files folder. I usually create folder databases in root of my C:\ drive so I don't have to look for them on 7th level. It looks that you don't have permissions to write to Program Files folder.
HTH
Piotr
...and your only reply is slàinte mhath
April 22, 2008 at 6:24 am
Make sure to enter the path correctly and avoiding any spaces. if necessary rename the mdf file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\lava ent.mdf
April 23, 2008 at 12:43 pm
I was able to restore a DB that was created in SQL Server Express 2005 to a Server Server 2005 Enterprise Edition.
The problem was that the Enterprise Edition database is on Windows Server 2003, and I am logged in with my Admin account. On my PC with SQL Server Express where I was having the problems and the errors, its a Windows Professional Edition. I have had problems with my Admin accont on my PC.
Thanks for all of the help!
April 25, 2008 at 10:59 pm
[font="Courier New"]
pbyrum (4/21/2008)
Here is the error message:Restore failed for Server 'pb003070\express'. (Micrsoft.SqlServer.Express.Smo)
System.Data.SQLClient.SQLError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetFor Creation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\lava ent.mdf'. (Micrsoft.SqlServer.Express.Smo)
pbyrum,
Provide modify privilege to SQLservice for the folder "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\" and then try restoring again. From the error you can see there is no privilege for sqlservice ID.[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply