Basically in an upgrade scenario we want to preserve the user's database file (obviously), and as a preventative measure we add the file to the move file table and it is copied to a different directory.
The .ldf file gets copied to this directory without problems.
The default .mdf file will get copied to this directory without problems.
However, if I import a fake large database that has pseudo real data in it, the copy fails during the install with an error 1310.
Error 1310. Error writing to file: C:\Program Files (x86)\Common Files\wiseBUAmazingCharts.mdf Verify that you have access to that directory.
Is there a size limit that I am unaware of? I have tinkered with the VM memory size (6GB of memory), there is plenty of hard disk space, etc.
I know that we are not dealing with permissions issues here because if I just leave the default database in place the process works correctly and the files copy correctly.
I have consulted MSDN and they do not indicate anything on the move file action or the move file table page regarding file sizes. The database in question is nearing 3GB in size. The default size is only about 10MB.
So far I have not seen any problems on Windows 7, Vista, XP.
I just noticed that the file size is listed as -1140523008, that is probably the reason it is not writing to the drive, due to an invalid file size. The file size is 2.93GB, I bet the Move File table tries to list the file in bytes.
Edited by danl65, 10 October 2012 - 18:49.