Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2009-11-16 : 17:47:53
|
| Hello,I am creating a database and I don't think I have a reason to create multiple filegroups.So I am using:exec sp_configure 'filestream access level', 2;reconfigure;go alter database WaterCompany add filegroup WaterCompany contains filestream;goalter database WaterCompanyadd file ( name = N'WaterCompany', filename = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\WaterCompany' ) to filegroup [WaterCompany];gouse WaterCompany;goI get the following error:The logical file name "WaterCompany" is already in use. Choose a different name.No rows affected.(0 row(s) returned)FILESTREAM data cannot be placed on an empty filegroup.No rows affected.Does this mean that I cannot have a file group with the same name of the database?How can I see all FileGroups onmy SQL Server and Delete them?Are they deleted when I delete a database?Thanks,Miguel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-11-16 : 18:51:03
|
| It has to do with the logical names, not the database name. Your primary data file's logical name is probably WaterCompany, so use something else. I use WaterCompanynn for my next files such as WaterCompany02, WaterCompany03, etc. Also specify an extension of ndf for your secondary data files.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
File Group