October 25, 2007 at 10:31 am
Hi Guys,
I am trying to add a database to my SQLServer instance that is located the network but everytime I go to attach it it says file not found. I am working from my machine and don't have enough space on machine to do the same.
I mapped the share to my machine but still nothing changes.
This is what I have done.
EXEC sp_attach_db @dbname = 'AuditMSLMaster',
@filename1 = 'M:\AuditMSLMaster.mdf',
@filename2 = 'M:\AuditMSLMaster_log.ldf'
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "M:\AuditMSLMaster.mdf" failed with the operating system error 3(error not found).
Ìs this allowed?
Thanks
M
October 25, 2007 at 6:32 pm
October 25, 2007 at 9:03 pm
As indicated by the KB article, this sort of solution isn't generally recommended. What our DBAs do to get around this issue is they have large USB hard drives, which are treated as local drives as far as SQL Server is concerned.
K. Brian Kelley
@kbriankelley
October 25, 2007 at 11:39 pm
Its better to copy the physical files to local disk and attach, since in our case the performace was went down very much as it wholly depends on network traffic.
Regards..Vidhya Sagar
SQL-Articles
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply