February 13, 2004 at 12:49 pm
To all the sql gurus out there -
I believe it was on this site a few days ago that I came across an article that said that a database can be backed up with a password option and to restore such a database, the dba would have to provide the necessary pwd.
I am in the middle of researching security and found this really interesting as I have to send my application & database across hills & dales for integration testing and thought it would be really neat if I could password protect my database.
Does anyone know what I'm talking about or was this just a gleam in someone's eye that I misinterpreted ?! All research on the Net has yielded to naught so far - HELP!
**ASCII stupid question, get a stupid ANSI !!!**
February 13, 2004 at 2:47 pm
I don't think it was availble in 7.0, but if you're using SQL 2000 check Books on line, type in "Password Protect" and it should take you to the "Administering SQL Server section". This procedure will protect you from unauthorized restores if someone were to 'borrow' a copy of your backups and attempt to restore them someplace else. It won't however protect the media from being erased if a format operation is performed. Hope this helps.
My hovercraft is full of eels.
February 14, 2004 at 4:07 pm
Yes - it does help thank you! I found the actual script under "backup database" in the books online - but this whole feature is so downplayed that I guess it's not worth that much of a dba's time right ?!
Anyway, thanks again.
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply