InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:06:23 GMT20http://www.sqlservercentral.com/Forums/Topic601207-359-1.aspxYou cannot restrict which client application is used to send a restore command. All you can do is control who has permissions to do a restore. By default only sysadmins and dbcreators and the dbo have the right to restore a database. Wed, 12 Nov 2008 06:04:29 GMTMarkusBhttp://www.sqlservercentral.com/Forums/Topic601207-359-1.aspxHi,What i need is that no body should be able to restore the database using SQL Editor (Restore Statement). Restoration should happen only with a tool that i have designed.SairamWed, 12 Nov 2008 04:04:42 GMTsairamshttp://www.sqlservercentral.com/Forums/Topic601207-359-1.aspxCould you explain a bit what you mean by "unnecessary restoration" ? Are you looking for object level restore options or what?Wed, 12 Nov 2008 03:49:32 GMTMarkusBhttp://www.sqlservercentral.com/Forums/Topic601207-359-1.aspxHi,How will i avoid unnecessary database restoration? Is there any method to avoid it?ThankssairamWed, 12 Nov 2008 02:45:13 GMTsairams