How To Backup and Restore Secured Back Up File in SQL SERVER

Posted by Jeetu_choudhary12 under Sql Server category on 9/13/2011 | Points: 40 | Views : 2020

Post Code |

Search Codes |

Code Home

--Let suppose we have database and we want to make secured backup,
--If we can do it by the Given below command. We have database named Sample.

BACKUP DATABASE Sample TO DISK='C:\Sample.BAK' WITH PASSWORD='jeetu'

--Now Given Below Command will Restore the Backup File. Make sure that
--the another Server should have Same name DATABASE otherwise Create New DATABASE in which Server You want to Restore AS given Below:

create database Sample

RESTORE DATABASE Sample
FROM DISK = 'C:\Sample.BAK'
WITH REPLACE,
MOVE 'Sample' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Sample.MDF',
MOVE 'Sample_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Sample_Log.LDF',
password = 'jeetu'

Alert Moderator

Bookmark It

Comments or Responses

Posted by: T.saravanan on: 9/12/2011 Level:Silver | Status: [Member] [MVP] | Points: 10

Kindly post your code inside the code tag.

Latest Code Snipptes