Solved

Table filegroup and Text Filegroup

Posted on 2006-07-02
2
697 Views
Last Modified: 2010-05-18
Hi,
What's the difference between Table filegroup and Text Filegroup? can i say that table filegroup is the table use to save database records? and how about text filegroup?
0
Comment
Question by:motioneye
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 17028741
The table filegroup is where the table is stored, the text filegroup is where text or image type data (i.e. binary data  like Word or JPEG files) in the table are stored .
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17028973
to add to the explanation:
in sql server, short values of TEXT data can be store inline in the table filegroup, while longer text value will be store in the text  filegroup, and in the row itself will only be stored a pointer value. This will be transparent for the SQL using the values.

This "splitting" is used for better managibility of the ususally rather large TEXT database parts, to be able to configure backups in a more easy way.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Backup Question 2 29
Solar Winds can't see SQL Server Express 17 30
Database Integrity 1 48
Acces SQL Insert Problem 6 28
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question