Database partitioning error in sql server
Posted on 2014-01-22
We have implemented DB partition in one of our prod sql server.
While executing stored proc, we are receiving below error every time.
Please advise how to resolve below error.
Msg 1834, Level 20, State 1, Line 5
The file 'H:\MSSQL10.XYZ\MSSQL\Data\H1_Partition\Raw_Partitions\DF_20091221.ndf' cannot be overwritten. It is being used by database 'H1_Partition'
Msg 1828, Level 20, State 4, Line 5
The logical file name " DF_20091221" is already in use. Choose a different name.
Msg 622, Level 16, State 3, Line 17
The filegroup "FG_20091221" has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added.
The statement has been terminated.