I need to move a 900GB MDF from one drive to another drive. I added a new 2tb drive to my server that I want to move the MDF into.
I tried copying multiple ways with no real luck and ended up just bringing it back online where it was.
Here's the speeds I was seeing, SQL services were stopped during the attempted copy.
I am not sure why the speeds are so slow. I had a 1.5gb installer file out on the server, I copied that into the new drive, using file explorer I copied that at 75mb/sec however when using another server using the UNC paths, I copied at 750Mb/sec according to file explorer. So it is strange that using the UNC paths I was able to get a faster speed.
Any ideas on how to copy it over? I don't want to log ship it over, I already have replication running on that DB.