SQL server restoration with limited user rights

  • vs.satheesh


    Points: 2370


    In my production server we are using sql server 2005 standard edition. My requirements is sql server databases restoration with limited user rights.This user only can able to restore the full and TL backups.I am already having solution for backup of particular database.

    In my condition is restoration user should not access the database. Any good third party open source tools also please suggest me.

  • Lowell

    SSC Guru

    Points: 323450

    you can create a SQL job or a stored procedure with Execute As Owner.

    the SQL job or procedure would contain the restore command in it,and you grant the limited end user EXECUTE ON MyRestoreProc, or on a different proc which starts the job via sp_start_job;

    so the end user does not have db_owner or sysadmin rights, for example, but can restore due to the proc.

    the procedure most likely has to exist in another database(ie master) so that it can disconnect users and restore the target database.


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

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