November 10, 2007 at 4:20 pm
I need help urgently.
I have 2 machines with sql server 2005 enterprise installed on windows server 2003
Enterprise. I need to partition a table and place each partition on diferent machines
I tried with the following:
---
dbcc traceon (1807);
go
ALTER DATABASE AdventureWorks
ADD FILE
(
NAME = 'ARCHIVO3',
FILENAME = '\\PC1\Management Databases\arch1_LOG.NDF',
SIZE = 10MB,
MAXSIZE = 100MB,
FILEGROWTH = 1MB
)
TO FILEGROUP GRUPOARCHIVOS3
---
But when I execute it returns the following error:
"Mens. 5110, Level 16, State 2, line 17
Directory lookup for the file "\\PC1\Management Databases\arch1_LOG.NDF"
failed with the operating system error 5(error not found). "
I`ve tried disabling the indicator trace 1807.
I am working with windows authentication.
Could Someone tell me why it's not working and what can I do?
Thanks!
November 10, 2007 at 6:19 pm
Hi,
Check the below steps and make sure you haven't missed any step.
1.) Dbcc traceon(1807) is not effective until you restart sqlservices, so you need to add the above trace in SQL server startup parameter(this can be done via SQL server configuration manager) and then restart sql services to make it effective.
2.)Make sure your SQL server startup account has modify privilege in the path '\\PC1\Management Databases\"
3.) Then try attaching the physical file
PS: Error 5110 clearly shows that network cant be attached so you need enable trace as mentioned above since IO operations are dependent on network speed
Regards..Vidhya Sagar
SQL-Articles
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply