any way to increase speed of restore ?
we have 230 GB db on physical server - Server_A (24 CPU, 32 GB RAM)
I use THREADCOUNT = 32 , COMPRESSION = 3 , it takes only 11 min backup db to SUN drive - server_S
for data mirroring I need to restore this db on another server (250 km away Server_B
Currently I run restore on server_B (not a physical server
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [Prices ] FROM DISK = ''\\server_S\server_A_Prices.sqb'' WITH NORECOVERY, DISCONNECT_EXISTING, REPLACE"'
restore time is 6,5 hrs
is any way to speed up restore process by changing options in
master..sqlbackup '-SQL "RESTORE DATABASE ?