SQLServer附加数据库(操作系统错误5:“5(拒绝访问。)”)
SQLServer附加数据库（操作系统错误5：“5（拒绝访问。
）”）
SQL Server 2012中数据库附加的问题：
1、问题出现场景：（已知，可能包含我并不知道的因素，所以我没有办法保证按照以下条件设置后，⼀定会再现提⽰的错误）
（1）原数据库主⽂件（.mdf）存放在fat32分区；
（2）将要附加⽂件⽂件从fat32分区拷贝到NTFS格式的分区的指定⽬录中；
（3）附加⽂件；
2、错误提⽰描述：
（1）错误现象图⽚
3、错误解决：
注意：
1、以上情况在fat32的分区上附加⽂件，不会出现问题；在fat32分区上的数据⽂件，只要按照“附加”向导提⽰的⼀步⼀步进⾏，可以很顺利的附加数据库⽂件；
文件访问被拒绝
2、有关ntfs和fat32⽂件系统区别的相关信息的链接：
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.

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。