Post reply

Restore the Database ask Username and Password

  • September 2, 2011 at 11:26 pm

    #256613

    In our server the Billing Database. The Backup daily placed in d:\.

    When Restore the Billing Database to another system

    I want to ask User name and password Existing Server

  • September 3, 2011 at 11:30 am

    #1376783

    you can't.

    once a person connects to SQL server, additional verifications are not possible from SSMS.

    So if they have permissions to perform a a backup or a restore, you can't make them log in one more time, or anything like that.

    you'd be better off auditing and logging who is performing the actions you are worried about instead.

    can't you just take away the ability to backup and restore, to make sure it's only a dba qualified event? sounds to me like you want to tackle the problem after the fact. you should instead prevent unwanted restores from ever happening at all.

    you could build a net application for example, that does all those extra verifications, and train your users to use that to do the restores instead.

    Lowell

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