Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rahul Sharma
Starting Member
3 Posts |
 Posted - 2008-05-19 : 05:41:41
|
| Hi all,I have SQL server 2005 enterprise edition on windows server 2003 machine. when i took the back of the database from this sytem and try to restore the backup on SQL server 2005 R2 enterprise edition on client machine. it is giving me following error"Restore failed for Server '10.112.12.229'. (Microsoft.SqlServer.Smo)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\FX_Global_backup_200805141500.mdf'. (Microsoft.SqlServer.Smo)"Please tell what is the error about?Can it be possible to restore a back up of different operating system machine to other ? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-19 : 05:56:13
|
| It is saying that you do not have permissions to restore. Check your permissions on the client machine. |
 |
|
|
Rahul Sharma
Starting Member
3 Posts |
Posted - 2008-05-19 : 06:13:53
|
| I Checked I am the administrator of that machine and has sysadmin rights on the SQL server. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-19 : 22:57:44
|
| How did you restore? What's 'SQL server 2005 R2 enterprise edition on client machine'? |
|
|
|
Rahul Sharma
Starting Member
3 Posts |
Posted - 2008-05-20 : 03:05:50
|
| Actually i have SQL server 2005 enterprise edition SP2 and operation system is windows server 2003 R2 on client machine on which i am restoring my cube.I am doing the restoration by right click and select restore on the analysis service database |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 21:46:32
|
| Where is cube backup file? What kind of permission does your account have in AS? Can you restore cube in ssms on server directly? |
|
|
|
|
|
|
Restore failed on the Windows server 2003 R2