SQL Server 2012中数据库附加的问题：
1、问题出现场景：（已知，可能包含我并不知道的因素，所以我没有办法保证按照以下条件设置后，一定会再现提示的错误）
（2）将要附加文件文件从fat32分区拷贝到NTFS格式的分区的指定目录中；
2、错误提示描述：
（2）错误现象描述
3、错误解决：
（1）根据给出错误提示“.mdf文件拒绝访问”，初步判断是权限问题；
（2）在附加文件目录下找到.mdf文件，点击右键，查看“属性”，如下图进行操作：
（3）重新到management studio中进行附加操作：
仍然会有错误提示给出，但是注意观察，这次提示的内容已经不再是.mdf文件，而是.ldf文件，所以对.ldf文件进行同.mdf一样的处理。（步骤同第2步）
（4）再附加，不再提示错误，最终效果如下图：
可以看到一个新的数据库已经添加，名称对应的就是我们那个主数据文件的名称。
注意：
1、以上情况在fat32的分区上附加文件，不会出现问题；在fat32分区上的数据文件，只要按照“附加”向导提示的一步一步进行，可以很顺利的附加数据库文件；
2、有关ntfs和fat32文件系统区别的相关信息的链接：
(1)
A computer filing system is how your computer manages the information that is stored on its hard drive. The most common Windows filing systems are the FAT16, FAT32 and the NTFS filing systems. The FAT32 is the universally standard system because can be used by more versions of Windows than the others.
FAT32 filing system is the system used on older Microsoft Windows systems including Windows 95, Windows 98 and Windows Me. The name FAT32 describes how data is stored on the hard drive, in 32 bit chunks. A FAT32 filing system can be installed,
but is not recommended, on Windows 2000, Windows XP and Windows 2003. The FAT 32 filing system is superior to the older FAT16 system in that it supports disk partitions as large as two terabytes (2,048 gigabytes), whereas FAT16 only supports two gigabytes. However, FAT 32 also has limitations. The FAT32 system does not allow disk
compression using DriveSpace, it is not compatible with older disk management software and it runs a bit slower that FAT 16.
While the Windows XP, 2000 and 2003 can support the FAT32 system, it is recommended they run an NTFS (new technology file system) because it is a can handle more functions that the FAT32, including the capacity to support Unicode file names, proper security, compression and encryption. The NTFS system is supported by the windows nt, 2000, XP and Vista and 7, and is able to handle much more memory than either the FAT16 or FAT32 systems. The NTFS also allows computers to more efficiently use the space available to store information on their hard drive, provides a better system of cataloging files on your hard drive for better and faster retrieval, and provides better methods for executing basic file operations such as delete, copy and rename.
(2)
(3)
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请联系我们，一经查实，本站将立刻删除。
如需转载请保留出处：https://51itzy.com/kjqy/172228.html