Home
Topics
Microsoft SQL Server Administration
SQL Server Security
Can I encrypt and restore a database backup in SQL Server 2005?

Can I encrypt and restore a database backup in SQL Server 2005?

Roman Rehak, Contributor

In my project, there is a request to provide the user with an encrypted database. How can I use EFS (Encrypting File System) to encrypt, decrypt and restore the database backup file in SQL Server 2005?

Requires Free Membership to View

Login

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

SQL Server does not provide encryption for backups. You could, however, use third party products such as SQL Backup from Red Gate or SQL LiteSpeed from Quest to get this functionality, as well as many other useful features that these programs provide.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- data hiding
- data corruption

This was first published in October 2008

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- 'Big data' analytics spawns a revolution
  
  'Big data' analytics could fundamentally change how businesses operate, according to a keynote speaker at the SAS Analytics conference.
- Apache Hadoop spurs hopes but creates hardships for analytics users
  
  Described as cutting edge, hot, niche and hard to use, Hadoop, like all celebrities, has its shining moments and its dismal displays.
- Download the Big Data Report
  
  When you download this e-guide you will get expert strategies from Wayne Eckerson about how to integrate with Hadoop, some of the big data trends that is is seeing plus more about the future of Hadoop.
Data Center
- A virtualized data center is a happy data center, says survey
  
  Enterprises now run more than half of their applications in virtualized data centers, and the number continues to grow.
- What are DCIM tools? Test your knowledge with this quiz
  
  Vendors talk about DCIM tools like they're going out of style, but what do you actually know about them? Take our quiz to find out and learn more.
- How integrated virtualization makes a UCS work
  
  Unified computing pulls servers, SAN connections and networking on to one platform. Integrated virtualization aims to make management easier.
Data Management
- Zornes connects the dots between big data and master data management
  
  Consultant Aaron Zornes believes that MDM and big data were made for one another.
- IT pros reveal benefits, drawbacks of data virtualization software
  
  Attendees at Composite Software's Data Virtualization Day conference had plenty of advice for companies considering a data virtualization project.
- IBM takes on Oracle, SAP with new integrated data management systems
  
  IBM is introducing three new PureSystems high-performance appliances optimized for transactional and analytics uses involving large amounts of data.
DataManagement UK
- Dynamic Markets: CFOs see worth in data on balance sheet
  
  About 20% of UK companies are assigning a financial value to their data, according to research sponsored by SAS. But only 16% of UK companies have a formal data management strategy.
- Data ethics: Author warns of ethical pitfalls of data collection
  
  Heedless data collection in business analytics programmes is breeding moral hazards, according to author Frank Buytendijk.
- Data visualisation success hinges on solid storytelling skills
  
  Tableau's Jock Mackinlay explains why data is inert and worthless without the twin practices of visualisation and storytelling.
Oracle
- How HR Increases Value
  
  Modern applications and leading technology provided the foundation for Oracle to become what it is today. And so did their talent pool. How can you benefit from the way they built their strategic HR function—away from the administrative back office—to drive business in support of a company that was shooting for 80 acquisitions over an 8 year timeframe? Hint: they used IT to consolidate onto a single system and embraced an HR transformation that had never been seen before.
- Social Recruiting Guide: How to Effectively Use Social Networks and Avoid Legal Risks
  
  Social networking sites are some of the most powerful tools available to recruiters today. If you're not sure where to start with a social recruiting strategy, this paper outlines why social recruiting is becoming an imperative today, what considerations you need to be aware of, and what first steps you can take. Plus you get the top 7 questions to consider before you make the leap to social networking.
- Building Critical-Talent Pipelines
  
  Get a 12-step methodology for building critical-talent pipelines that are supported by a robust technology platform designed to allow you to accurately assess and predict gaps in critical skills and competencies, design more-effective development programs and recruiting strategies, improve ongoing efforts and introduce hidden efficiencies within your current infrastructure, and more.
Content Management
- For effective customer experience management, rethink WCM
  
  Organizations that are serious about customer experience management may need to rethink their approach toward Web content management.
- Well planned is well executed with an information governance framework
  
  While there are common foundational pillars for effective information governance, there is no one-size-fits-all approach and success is typically tied to execution.
- Secrets of Effective SharePoint Deployments
  
  Secrets of Effective SharePoint Deployments
Windows Server
- Word, Kerberos vulnerabilities highlight busy October Patch Tuesday
  
  Improperly time stamped certificates mean rereleased patches, on top of fixes for Microsoft Word and Kerberos vulnerabilities this month.
- Ensuring hardware compatibility with a Windows Server 2012 upgrade
  
  With Windows Server 2012 available, admins have a lot to consider when it comes to hardware. Here's what you need to know before you make the move.
- Windows Server 2012 failover clustering makes high availability possible
  
  In Windows Server 2012, failover clustering is configured to work with scale-out file servers for continuous availability. Here's how it works.

All Rights Reserved,Copyright 2005 - 2012, TechTarget