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)

AS [Percent Complete],CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time],

CONVERT(NUMERIC(10,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min],

CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min],

CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours],

CONVERT(VARCHAR(1000),(SELECT SUBSTRING(text,r.statement_start_offset/2,

CASE WHEN r.statement_end_offset = -1 THEN 1000 ELSE (r.statement_end_offset-r.statement_start_offset)/2 END)

FROM sys.dm_exec_sql_text(sql_handle)))

FROM sys.dm_exec_requests r WHERE command IN (‘RESTORE DATABASE’,’BACKUP DATABASE’)

Comments