February 1, 2002 at 11:51 pm
Hi,
When i create a database using mapped drive or unc path i get a 5110 error i use SQL 2k Can some one expalin how can i get this fixed
February 2, 2002 at 8:01 am
It's looking for a local drive. If you are using shared storage, such as connecting to a SAN or SCSI drive array, there should be appropriate hardware (and/or software) to make the drives appear local to Windows 2000. From Books Online:
quote:
Important Microsoft® SQL Server™ 2000 data and transaction log files must not be placed on compressed file systems or a remote network drive, such as a shared network directory.
I don't know of any workaround but perhaps someone else does. Essentially, SQL Server wants to make sure that something as simple as a broadcast storm or even someone tripping over the cord doesn't break the connection it has to the database files.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
Edited by - bkelley on 02/02/2002 08:02:16 AM
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply