Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What are the best options to secure backups without using third part tools ? Expand / Collapse
Author
Message
Posted Sunday, September 23, 2012 10:28 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, October 26, 2014 9:57 PM
Points: 1,563, Visits: 2,616
Experts,

What are the best options to secure backups without using third part tools ?

I am able to think of the below options.

Keep in disks/tapes at remote locations.
Secure with password (I don't see this option in SSMS though ).

Anything else ?


Thanks in advance.




Post #1363323
Posted Sunday, September 23, 2012 10:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:15 PM
Points: 35,399, Visits: 31,959
Joy Smith San (9/23/2012)
Experts,

What are the best options to secure backups without using third part tools ?

I am able to think of the below options.

Keep in disks/tapes at remote locations.
Secure with password (I don't see this option in SSMS though ).

Anything else ?


Thanks in advance.






Zip it with a password.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1363326
Posted Monday, September 24, 2012 12:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, October 26, 2014 9:57 PM
Points: 1,563, Visits: 2,616
Thanks Jeff.

Keeping at remote locations and securing with password are the only options ?

Thanks again.
San
Post #1363346
Posted Monday, September 24, 2012 4:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 40,258, Visits: 36,681
Upgrade to SQL 2008 and use TDE on the database (Enterprise edition only). Otherwise 3rd party tool of some form (backup tool, password protected archiver, etc)

The password on SQL backups is not secure, books online does make that point.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1363396
Posted Monday, September 24, 2012 5:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:15 PM
Points: 35,399, Visits: 31,959
Joy Smith San (9/24/2012)
Thanks Jeff.

Keeping at remote locations and securing with password are the only options ?

Thanks again.
San


No. The only reason why I suggested what I did was because it's free, relatively easy, and offers good security. When you said that you wanted to avoid 3rd party tools, I suspected that the word "free" was an important factor.

Like Gail said, you could use TDE but study the ramifications of that carefully before you do it.

As she also said, securing it through an SQL Password isn't the right thing to do.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1363431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse