how can create a secure backup of a database in Microsoft Sql Server 2000
i want to perform this task from Visual Basic.
creating backup of secure backup of database
Hot Topic
- Dynamic where clause with if..else or case
- Parameters visibility
- Error getting output.Buffer on synchronous custom transform
- Can't connect to SQL Server 2005
- SQL Server 2005 - Generate DB Script...
- Objects in precedence constraints?
- SERVER 2003 Standard x64 will not run ASP connecting to SQL
- Package Configuration for Oracle Connections
- SQL 2005 Enterprise June CTP Installation Error
- SSIS XML Source with random child ID??
SQL Server
- Function that returns a table
- Execute Mutiple Tasks In Debug Mode
- Return the data from a table ordered by its hierarchy
- Merge Join (Full outer join) never finishes.
- About plug-in algorithms in SQL Server 2005
- Create Trigger for View
- How to suppress the subreport when there is no data in it?
- Upgrade advisor can not process trace file
- Database query performance
- How to control the report export to a pdf in Landscape mode?
creating backup of secure backup of database
Chikodef
actually i have been told by some body that you can create a encrypted database backup of database that when you want to restore or when you want to attach to sql will require a password.
any idea
Pparl0627
Regardless of the interface used to request the backup, you end up with either a TAPE or disk file.
The only way to make this data secure is to physically protect the media on which the data is stored.
For disk backups, you can encypt the backup file. SQL Server does not provide its own encryption, but you can use NTFS EFS or other techniques.