We are in an environment where we need to restore the production db the size of around 600GB from daily backup to our UAT server.
We have currently do full backup and restore and as database grows it has slowed down the overall performance. Im not a DBA and wonder whats the best strategy to optimise this process.
Occasionally we also have experience very slow restore even after I enabled the instant file initialisation. Its processing in a normal speed but all of sudden from like 50 percent it processes extremely slow. Any idea where to begin the investigation?
The backup is compressed. The database only has about 43 VLFs. We just want to get production data in UAT. I have heard from someone it's better to use differential back up for our scenario but one thing I am not still clear is why it randomly slows down in the middle of restore.