Setting database security to prevent restoring databases on other SQL Servers

Tags:
Database Backup
Database security
Security
SQL Database
SQL Server
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are also bonded. However, when I restored that backup database to another SQL Server with a new ‘sa’, the entire database becomes entirely open. How can set my database security to prevent this from occurring?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Once a database is restored to another SQL Server that database is now under the total control of the new server. Any security that you set can be overwritten by anyone on the new server that has the correct server level rights.

If you have data which is sensitive and this is a potential problem you will want to encrypt your database backup with a product like <a href=”http://www.quest.com/litespeed-for-sql-server/”>Lightspeed for SQL Server</a>.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,140 pointsBadges:
    report
  • ATU
    That's a terrible security threat for user! I belive because I had tried, before we have a chance to backup the data with encyption, someone can actually stop the SQLserver services and copy both mdf & ldf files to a pc then attach to another SQL server! There must be a way to prevent this. TQ
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following