Database Restoration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Database Restoration

Database Restoration

Rate Topic

Display Mode

Topic Options

Author

Message

sairams

Posted Wednesday, November 12, 2008 2:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2008 10:08 PM
Points: 4, Visits: 7

Hi,

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

Thanks
sairam

Post #601207

MarkusB

Posted Wednesday, November 12, 2008 3:49 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 4,218, Visits: 3,875

Could you explain a bit what you mean by "unnecessary restoration" ?
Are you looking for object level restore options or what?

Markus Bohse

Post #601231

sairams

Posted Wednesday, November 12, 2008 4:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 12, 2008 10:08 PM
Points: 4, Visits: 7

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

Post #601235

MarkusB

Posted Wednesday, November 12, 2008 6:04 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 4,218, Visits: 3,875

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.

Markus Bohse

Post #601281

« Prev Topic | Next Topic »

Permissions