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) […]

sql

Differences Between SQL and NoSQL

Almost everyone in tech field will have knowledge of SQL database and have a good knowledge on either MsSQL, Oracle, MySQL or any other database. Technology changes rapidly and now the new buzzword in the database world is NoSQL. NoSQL database is getting widely adopted to solve various business problems. Difference between SQL and NoSQL […]