Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
 Posted - 2007-10-12 : 00:45:45
|
| Is it possible to set a password protection in an SQL Server 2000 backup file? If it is so, how?thanks in advance.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2007-10-12 : 00:54:06
|
| Example:backup database Database1to disk = 'E:\Test\Database1.Bak'with password = 'P@ssw0rd' |
 |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-10-12 : 02:09:17
|
| how about restoring this password protected database? Its giving me an error "Error 3279: Access is denied due to a password failure RESTORE FILELIST is terminating abnormally."How to restore database with password protected?Thanks in advance once more. Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-12 : 03:05:56
|
| you need to use the PASSWORD attribute for the RESTORE command too!Or am I missing something?Kristen |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-10-12 : 03:29:38
|
| Can we do this in Restore Database Task? I have a concern on password protected database backup file. coz Im putting the backup on jobs. Is it possible to hide that process if I used...backup database Database1to disk = 'E:\Test\Database1.Bak'with password = 'P@ssw0rd'of course I dont want anyone including myself seeing that script on my job process. Is there any better way?Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-12 : 03:35:10
|
| Can't think of a much better way.You could put that code into an SProc, use WITH ENCRYPTION, and run the SProc from your job.The WITH ENCRYPTION is not very robust for a determined hacker, but it will keep the casual observer out at least.Kristen |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2007-10-12 : 03:49:57
|
| Thanks kristen.There are lots of available decryption tool for stored procedures. Are all of those reliable in decrypting stored procedures? I'm thinking of adding a lot of commented context just before writing my procedure or putting it between those commented context before encrypting. How is that so?Any help is greatly appreciated.Want Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-12 : 04:02:51
|
"Are all of those reliable in decrypting stored procedures?"Dunno about All  , but on the odd occasion where my only copy of an SProc has been in the server, and not in the version control system  , the first thing I found in Google got me back the original source code in pretty good shape. So don't rely on it beyond keeping out the casual observer.I think SQL 2005 has stronger encryption, but I haven't checked that for myself."I'm thinking of adding a lot of commented context just before writing my procedure or putting it between those commented context before encrypting. How is that so?"I don't think that will help much. You could perhaps put the Password in the Registry, and have the Sproc get it from there - so someone who steals your database won't have the key ... but if they have stolen the database, or gained access, then they can probably see the registry too. All a bit catch-22.Note that the Backup File won't be encrypted, so folk with access to the file will be able to see the contents. Although I expect that actually restoring it from there will be tough. You need to use PGP or somesuch on the physical file, immediately after the backup is created, if you need that level of protection.Again SQL 2005 may have more comprehensive things that would help you (but you may not be in a position to upgrade overnight! Natch!)Kristen |
|
|
|
|
|
|
|
|
Set password protected on Backup file