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

get deleted data

How to Get Deleted Data Back

Most of us experts in multitasking, we always wins in this too, but when time flies we experience some consequences also, One of those is DELETING IMPORTANT FILES or FOLDERS PERMANENTLY then after knowing we can’t get it back we almost cry for it.. A good method for those who want to get their data back. This […]