creating filegroups on a db

getting the following error:
1. ALTER DATABASE [xx] ADD FILEGROUP [FG_Trade_2010]
GO

OK
2.
ALTER DATABASE [xx] ADD FILE ( NAME = N'FG_Trade_2010',
FILENAME = N'E:\SQLDATA\DATA\XX_Trade_2010_1.ndf' , SIZE = 51200KB ,
 MAXSIZE = unlimited , FILEGROWTH = 5000KB ) TO FILEGROUP [FG_Trade_2010]
GO
"failed with the operating system error 3(failed to retrieve text for this error. Reason: 15105)"

shanjAsked:
Who is Participating?
 
tigin44Commented:
check that the drive and the path exixst in the host...

E:\SQLDATA\DATA\
0
 
razvansocolCommented:
"operating system error 3" means "The system cannot find the path specified."
You can find out the messages for the operating system errors with NET HELPMSG.
Make sure that the specified path exists on the server (and that it's not a mapped network drive).
0
 
MrAliCommented:
It's always been a file level issue iwth me on os error 3.  Make sure:
-Your SQL Server service acct has write access to the listed folder
-Review NTFS permissions
-Make sure the folder exists
-Make sure it's not a 'mapped drive' as the other service user won't share your mapped drives
-Check it for physical disk errors
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.