February 16, 2006 at 5:54 am
I have taken the backup of data from sql server7.
with user as "sa"
Now I am trying to restore the data back in the sql on different user.
I am able to restore this then how my data is safe
Is it possible not to allow other user to restore the data.
thank you
February 16, 2006 at 1:58 pm
Sure you can..
If you dont want the user of appropriate fixed server and database roles to perform the operation the operation then you can set the pswd for the backup and the pswd needs to be provided while restoring the db...
When users connect to SQL Server, the activities they can perform are determined by the permissions granted to the accounts.
If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions default to members of the sysadmin and dbcreator fixed server roles and the owner (dbo) of the database.
Also using the third party tools like LiteSpeed you can do password protected backups andl also the backups can be compressed and encypted...
-Krishnan
February 16, 2006 at 9:59 pm
Krishnan thanks for suggestion.
But my problem is different, I didn't post properly in the previous message.
I have take backup using username : user1
I am able to restore the database on the different servers using user "sa". If this is possible then their is not security for backup file.
Actually i was working in Oracle db early, where i have to pass username and password while restoring db.
Is something like that is possible in Sql server 7
February 17, 2006 at 9:28 am
you can set the pswd for the backup and the pswd needs to be provided while restoring the db...
-Krishnan
February 17, 2006 at 9:27 pm
Hello krishnan,
I will be thankfull if you tell me that,how to set password for the database
February 20, 2006 at 9:31 am
My understanding is that even if you put a password on the DB, and even though the password is encrypted the backup file is still unencrypted. Whick kind of defeats the purpose of a password (if you are going to do security why not do it properly), as you can still be a victim of the old "open an unencrypted backup file in Notepad" trick.
Jake
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply