restore database

How to Restore Database in SQL Server

Restore Database Process To restore database we need to follow the below mentioned steps. Step-1: Restore filelistonly from disk = ‘F:\backup\ControllerLive_backup_2014_02_03_000007_5187682.bak’ Step-2: RESTORE DATABASE ControllerLive_Budget_test FROM DISK = ‘F:\Backup\ControllerLive_backup_2014_02_03_000007_5187682.bak’ WITH MOVE ‘ControllerLive’ TO ‘E:\Data\ControllerLive_Budget_test.mdf’, MOVE ‘ControllerLive_log’ TO ‘F:\Log\ControllerLive_Budget_test_log.ldf’ Go to find restore percentage SELECT command, percent_complete, start_time FROM sys.dm_exec_requests WHERE session_id = 69 SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete) […]