I am currently traveling on a month-long training assignment for Business Intelligence. For demonstration purposes, I use Virtual PC files and hands-on lab examples for attendees of the training. The size of my VPC file is about 15 GB. Initially, I copy this file to a USB Drive and then move it to other computers, as needed.
Recently, while trying to copy my VPC file to my USB drive I received the following error:
Error Copying File or Folder. Cannot Copy. There is not enough free disk space.
I had never experienced this problem before. I tried copying it a few more times using different copy methods and the command line. No matter what I tried, I received the same error message. I finally decided to check the file system of the USB drive and discovered that it is FAT32. Filesystem FAT32 only supports a maximum file-size of 4 GB file, where as filesystem NTFS does not have this limitation. I had not come across FAT32 for more that two years and had completely forgotten about this limitation. I re-formatted the USB drive with NTFS. After this, it worked fine and I was able to copy my large VPC file successfully.
I used GUI to format my drive, but if you prefer, you can also do it using Command Prompt.
While this article may not be directly related to SQL Servers, SQL Server Database files can be extremely large at times. If a SQL Expert faces this kind of situation in future, it may be helpful.
Reference : Pinal Dave (http://blog.SQLAuthority.com)