We have a 2gb live database that takes forever restore whenever I need some live data to test something. If I use idera it takes 5 mins at most. When I use the restore database command it can take almost an hour. How is idera able to do so much faster?
I use the following to restore:
RESTORE DATABASE dbname FROM DISK = 'path' WITH MOVE 'CMTS_dat' TO 'C:\db\MARTIN_Latest.mdf', MOVE 'CMTS_log' TO 'C:\db\MARTIN_Latest_log.ldf' ,REPLACE
If it has any data partitions then I'll use MOVE to do the partitions as well.