Questions tagged [filegroups]

In SQL Server, a filegroup is a logical collection of one or more physical files onto which the database will write.

20 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
0 answers
729 views

Remove table from DEFUNCT filegroup so we can recreate the table again in a different online filegroup

We have a BIG production database. We also have STG and UAT servers, where we restore the PROD database. One of the biggest tables (+250 GBs) in this PROD database is in the SECONDARY filegroup. We ...
Victor Barajas's user avatar
4 votes
1 answer
2k views

SQL Server data files in Windows Azure: filegroups and partitioning still applicable?

I just created a database using the new functionality "SQL Server 2014 data files on Windows Azure" and this works quite well. However, I have a table with a billion records and in our local ...
Ronald's user avatar
  • 41
2 votes
0 answers
1k views

Default filegroup, specified in the SQL Server CREATE INDEX statement, is ignored (ON [DEFAULT] storage clause)

Am I missing something? Documentation clearly states, that: ON "default" Applies to: SQL Server 2008 through SQL Server 2017 and Azure SQL Database. Creates the specified index on the ...
AlexM's user avatar
  • 21
2 votes
0 answers
440 views

SQL Server 2008 R2 - Two Files Stuck In Restoring Status

Background: SQL Server 2008 R2 mirrored and clustered. We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
dajonx's user avatar
  • 91
1 vote
1 answer
54 views

What is an example to understand that having multiple data files helps with latch pages in parallel?

You will always benefit from multiple data files, because then SQL Server is able to latch multiple system pages in parallel in the Buffer Pool. Link: https://www.sqlpassion.at/archive/2016/08/29/...
variable's user avatar
  • 3,593
1 vote
0 answers
64 views

What else are there in the file

I am trying to empty a file in order to remove it from database. First of all, I moved the tables and indexes with creating clustered and nonclustered indexes with DROP_EXISTING = ON in another ...
Meyssam Toluie's user avatar
1 vote
0 answers
75 views

Removing files from a filegroup

I am writing some T-SQL code to retrieve the file names that make up a file group so that I can remove the files and the related filegroup. The way that I coded it is below: set @cnt = (select ...
Paul McKibben's user avatar
1 vote
1 answer
59 views

Where would the table data be if you had 3 filegroups, 2 with tables and 1 with all indexes?

I'm studying filegroups at the moment as I haven't used them much before. A class I'm taking mentions the above scenario. I was wondering if I'm understanding it correctly: Would the 2 filegroups ...
Crattik's user avatar
  • 11
1 vote
0 answers
111 views

Transactional Replication and distribution database size

I have a transactional replication set up with initialize from backup. In the secondary database server,i have a drive(d:) for data files alone. I have noticed that this drive is getting filled and i ...
user9516827's user avatar
  • 1,315
1 vote
0 answers
126 views

Filegroup per Table partition - remove filegroup and re-add filegroup

I've seaching all over the web for a solution, if it is even possible... I'm not a savvy in Partitioned tables in different filegroups... Our software is supported by SQL 2008 R2 SP2 to SQL 2017 for ...
JohnG's user avatar
  • 1,081
1 vote
0 answers
77 views

Any performance gains from having identical clustered and nonclustered indexes on table on different filegroups?

I am attempting to rearchitect our MSSQL database such that we have two filegroups, one for data, on a 15K HDD, primary, and one for indexes on a separate SSD, indexes, in order to realize some ...
dav3ypants's user avatar
1 vote
0 answers
498 views

Moving Large Tables and All Indexes to a new File Group

I'm looking at implementing File Groups on an existing database that's roughly 600GB. The largest hurdle I have is actually setting this up in production. I need the database to still be available but ...
nikolifish's user avatar
1 vote
0 answers
686 views

500GB Data Warehouse - how to split it into FileGroups?

OK, so I have: 500 GB DW 5 GB in smaller DBs 220 GB TempDB 350 GB in Log files. My machine is Fujitsu Primergy 64 cores (with HT) and 192 GB RAM. I have several IO locations: 540 GB in-server HDD ...
user avatar
1 vote
0 answers
277 views

file extension of the file types cdump, incident, trace

I need to know the file extension of the file types cdump, incident, trace, alert. Actually I want to create files of the above types manually using mkfile command. There are no existing files of ...
mahendra's user avatar
0 votes
1 answer
282 views

How to remove unallocated space after partitioning

I've recently done partitioning on a table (postcode column) and created new filegroups for each postcode. Now that it is no longer using the PRIMARY filegroup, the file size is still as it is. How do ...
aYasser97's user avatar
0 votes
0 answers
410 views

SQL Server File or Filegroup Creation Date

Is there a way to find out when a File was added to a filegroup in SQL Server. Or how to determine when a filegroup was created? I've tried querying the sys tables looking at the lsn information and ...
user210084's user avatar
0 votes
0 answers
51 views

How does the data move within a filegroup for its respective secondary data files

I am confused or do not have better understanding on how SQL works in below scenario and need some views: For a database X, we have a FILEGROUP named FG which has 4 data files tagged to it as below ...
BeginnerDBA's user avatar
  • 2,169
0 votes
1 answer
112 views

Database still reports 600GB after removing 500GB File

I have a database with three files Log Primary Data File Blob Data file the database was becoming too big to manage (600GB) so we removed the blob data (500GB) into FileStorage outside the DB. we ...
RoughPlace's user avatar
0 votes
1 answer
7k views

Error: 'PRIMARY' filegroup is full

We have increased disk space on the SQL Server, and there is definitely enough space on the server, yet below error is raised: com.softmar.fileserver.WebFileException: com.microsoft.sqlserver.jdbc....
Marieke Smit's user avatar
-1 votes
1 answer
147 views

Attach of renamed files conflicts with original files

I am having difficulties attaching DB in a certain environment while the same scenario works in my dev or other production instances. SCENARIO There is a backup of database files (MDF, NDF, LDF, ...
jericzech's user avatar
  • 945