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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 do you do your backups with a password?

Author  Topic 

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2005-05-05 : 11:24:35

Should I be doing this? How secure is the password? I've never felt comfortable backing up my databases anywhere off the server (shared tape backup from hosting company), but maybe this would ease my worries.

Thanks for any tips!

mike123

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-05 : 17:25:17
I've never used a password on the backups.

Tara
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2005-05-06 : 03:31:07
We don't use passwords for backups, either. We do, however, keep a backup in an off-site location as part of our disaster recovery plan.

HTH

=================================================================
Some mistakes are too much fun to only make once.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-06 : 07:31:47
i've read somewhere here at sqlteam a guy asking the security of backup files and realized no matter where the files are saved, someone will hack into these files

though from what i read from BOL, the password option for backups may not be too secure, IMHO it represents a certain level of security especially over the network. Read BOL and you'll be able to gauge if you really need to apply a password

i know i will

--------------------
keeping it simple...
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-05-06 : 07:48:49
I go back to Jims ground rule of security.
If they can't get at it they cant hack it.
It all starts with network security and a good firewall.


Jim
Users <> Logic
Go to Top of Page

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2005-05-06 : 12:57:20
thanks for all your input! :)

mike123
Go to Top of Page
   

- Advertisement -