Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Filegroups Rss

   Items 1 to 6 of 6   
 

T-SQL Tuesday #40– File and Filegroups

It’s the second Tuesday of the month and time for T-SQL Tuesday again. This is a monthly blog party, where...  Read more...
By Steve Jones 2013/03/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,193 reads

T-SQL Tuesday #40 - Proportional Fill within a Filegroup

T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter).  The topic is about File and Filegroup...  Read more...
By Patrick Keisler 2013/03/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 948 reads

Move all SQL Server indexed views to a new filegroup

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...
By Additional Articles 2013/02/11 | Source: MSSQLTips.com | Category: filegroups
Rating: (not yet rated)  Rate this |   Briefcase | 2,734 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,124 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,124 reads

Using Partitioned Tables with Multiple Filegroups for High Availability

Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.  Read more...
By Additional Articles 2008/11/20 | Source: MSSQLTips.com | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 2,652 reads
   Items 1 to 6 of 6   
 
Tags
blogs (2)    
administration (1)    
backup / restore (1)    
filestream (1)    
high availability (ha) (1)    
indexed views (1)    
partitioned tables (1)    
storage management (1)    
t-sql (1)    
utility (1)