August 3, 2012 at 1:13 pm
I’m trying to restore the database from SQL 2005 to SQL 2008 R2 Using litespeed , O/S 2008 . When I use script
exec master.dbo.xp_restore_database @database = N 'XYC',
I get following error message.
Msg 229, Level 14, State 5, Procedure xp_restore_database, Line 1
The EXECUTE permission was denied on the object 'xp_restore_database', database 'master', schema 'dbo'.
Msg 229, Level 14, State 5, Procedure xp_restore_database, Line 1
The EXECUTE permission was denied on the object 'xp_restore_database', database 'master', schema 'dbo'.
Msg 229, Level 14, State 5, Procedure xp_restore_log, Line 1
The EXECUTE permission was denied on the object 'xp_restore_log', database 'master', schema 'dbo'.
Can someone please help.
Thank you
August 3, 2012 at 5:07 pm
What rights does the user being used have? It should be sa, a user in the sysadmin, or dbcreater role.
August 3, 2012 at 9:17 pm
It worked. I was trying with my credential which didnt have proper authority. I tried with "sa" it, worked.
Thank you for your help. Apperciate.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply