Post reply

Database Restoration

  • November 12, 2008 at 2:45 am

    #195942

    Hi,

    How will i avoid unnecessary database restoration? Is there any method to avoid it?

    Thanks

    sairam

  • November 12, 2008 at 3:49 am

    #897405

    Could you explain a bit what you mean by "unnecessary restoration" ?

    Are you looking for object level restore options or what?

    [font="Verdana"]Markus Bohse[/font]

  • November 12, 2008 at 4:04 am

    #897409

    Hi,

    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.

    Sairam

  • November 12, 2008 at 6:04 am

    #897448

    You 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.

    [font="Verdana"]Markus Bohse[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

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