shanj
asked on
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.nd f' , 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)"
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
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)"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
-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
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).