asked
Adding File to Filegroup
Need some assistance, I'm kind off new in the SQL world and I'm having an issues with adding a file. The following is the code I'm using. I'm getting *msg 5009, level 16 stating one or more files listed could not be found or initialized, furthermore, I get this other msg 5123, lvl 16 stating create file encountered operating system error 5(access denied)* Alter Database Adventureworks2008 Add File (Name = N's AdventureworksFT', FileName = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008 FT.ndf') To Filegroup AWFullTextFG Go
Is there a file group "AWFullTextFG"? It appears in your example there are spaces in the "path".
Did you check for a space in the "path"? Can you navigate to the folder and create a file simple text file? What account is SQL Server running under? Does that account have permissions? Try a different location. Create a C:\testTemp folder and then try and create the file in that location?
Something with the path. I tried the statement it and just changed path to fit my laptop, and that works. So have a look at the path or security for the \Data folder. If you copy the whole path C:\program files\.. (ctrl-c) and paste it in explorer, does that work?
I copied the entire path from C: and I ran it and it worked. Thank you for the advice.
This error occurs when you try to use a file in a statement, however this file couldn’t not be found or initialized.Make sure you have created that File group.If file group exists then there might be some problem with path...that worked for me...
16 People are following this question.
