Tuesday 23 September 2014

Restore SQL DataBase Backup On same or Different Server Using SQL Command

Most of the time i am struggling to restore to the back from interface, Different types of errors every time i need to face,  Using SQL command its more easy just have to make sure about the file names are correct and  current user have permissions to access.

You must have a Valid SQL Backup file with .bak extension, You can use this Sql command to restore the back on the same server or different Server.

Open SQL Server
Click at New Query
use the below query , just the required Parameters according to you files and locations.

Restore filelistonly from disk = 'FULL-PATH\FileName'

restore database DatabaseName
from disk = 'FULL-PATH\FileName'
move 'Logical Name for Data File to 'FULL-PATH\FileName.mdb'

move 'Logical name for Log Fileto 'FULL-PATH\FileName.ldf'

Restore filelistonly from disk = 'C:\Backups\WSS_Content_2010_Portal-Full-Database-Backup'
restore database WSS_Content_2013_portalTest
from disk = 'C:\Backups\ WSS_Content_2010_Portal-Full-Database-Backup'
move 'WSS_Content_2013_portalTest' to 'C:\Backups\WSS_Content_2013_Portal.mdf',

move 'WSS_Content_2013_portalTest_log' to 'C:\Backups\WSS_Content_2013_Portal_log.ldf'

No comments:

Post a Comment