How To Secure Your Database Backup With Password In SQL Server

In this post we will learn How To Secure Your Database Backup With Password In SQL Server.Securing your backup in SQL Server with password is so much easy, but it is not that much secure.For more security of your backup by placing it on an encrypted file system or physically securing a tape in a safe.SQL Server 2005 supports native encryption, using industry standard encryption algorithms.If your database contains extremely confidential information,such as credit-card information, it is probably better to encrypt it within the database rather than simply relying on some sort of backup encryption or password.

Query To Backup and Restore The Database with Password:

----BACKUP DATABASE WITH PASSWORD----

BACKUP DATABASE DEV
TO DISK = 'A:\DEV.BAK' WITH PASSWORD='HIGHTECHNOLOGY'

----RESTORE DATABASE WHOM BACKUP IS TAKEN WITH PASSWORD----

RESTORE DATABASE DEV
FROM DISK = 'A:\DEV.BAK' WITH PASSWORD='HIGHTECHNOLOGY'