September 29, 2011 at 5:50 am
v_kozachuk (9/29/2011)
Thanks for the question.But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"
The article on technet (http://technet.microsoft.com/en-us/library/cc966545.aspx) explains us
tempdb supports only one data filegroup and one log filegroup.
There's no such thing as a log file group. From Files and Filegroups Architecture in Books Online:
Log files are never part of a filegroup. Log space is managed separately from data space.
Still not convinced? Write a CREATE DATABASE statement that places log files in a file group 😛
September 29, 2011 at 6:05 am
Good question. You can have multiple files, but only 1 filegroup. Thanks.
http://brittcluff.blogspot.com/
September 29, 2011 at 6:11 am
SQL Kiwi (9/29/2011)
v_kozachuk (9/29/2011)
Thanks for the question.But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"
The article on technet (http://technet.microsoft.com/en-us/library/cc966545.aspx) explains us
tempdb supports only one data filegroup and one log filegroup.
There's no such thing as a log file group. From Files and Filegroups Architecture in Books Online:
Log files are never part of a filegroup. Log space is managed separately from data space.
Still not convinced? Write a CREATE DATABASE statement that places log files in a file group 😛
This is not new information for me. But i thought what the question with a trick 🙂
And then i've found the article with statement - "tempdb supports only one data filegroup and one log filegroup"
Best Regards,
Vadym Kozachuk
September 29, 2011 at 7:03 am
v_kozachuk (9/29/2011)
SQL Kiwi (9/29/2011)
v_kozachuk (9/29/2011)
Thanks for the question.But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"
The article on technet (http://technet.microsoft.com/en-us/library/cc966545.aspx) explains us
tempdb supports only one data filegroup and one log filegroup.
There's no such thing as a log file group. From Files and Filegroups Architecture in Books Online:
Log files are never part of a filegroup. Log space is managed separately from data space.
Still not convinced? Write a CREATE DATABASE statement that places log files in a file group 😛
This is not new information for me. But i thought what the question with a trick 🙂
And then i've found the article with statement - "tempdb supports only one data filegroup and one log filegroup"
Best Regards,
Vadym Kozachuk
You have to be carefull with the wording of a KB article. They are not edited by a technical writing professional. They usualy come from information submited by support technicians. The statement is partialy true since all log files share the log file group in a sense. But there is no create database statement that can put a log file in a differant group.
September 29, 2011 at 7:08 am
Great question. More like this would be nice. 😎
I learned about this one before when someone asked me to help upgrade a SQL server from 6.5 to 7.0. Seems that the upgrade UI gave you an option to do this for the tempdb and model databases.
http://support.microsoft.com/kb/236045
:hehe:
September 29, 2011 at 8:42 am
good question - tks for the feedback on the log file[group] too.
No to belabor this point but if you go into the Database properties and look at the Files section, it is quite apparent that there is no Log Filegroup. Under "Filegroup" for your log file it lists, "Not Applicable" showing that there is no file group association.
Cheers
September 29, 2011 at 8:56 am
OzYbOi d(-_-)b (9/29/2011)
No to belabor this point but if you go into the Database properties and look at the Files section, it is quite apparent that there is no Log Filegroup. Under "Filegroup" for your log file it lists, "Not Applicable" showing that there is no file group association.
Thanks - you saved me the job of posting a screenshot of that 🙂
September 29, 2011 at 9:20 am
I agree, this is a good question. Might even use this for my next interview.
September 29, 2011 at 10:48 am
SQL Kiwi (9/29/2011)
v_kozachuk (9/29/2011)
Thanks for the question.But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"
The article on technet (http://technet.microsoft.com/en-us/library/cc966545.aspx) explains us
tempdb supports only one data filegroup and one log filegroup.
There's no such thing as a log file group. From Files and Filegroups Architecture in Books Online:
Log files are never part of a filegroup. Log space is managed separately from data space.
Still not convinced? Write a CREATE DATABASE statement that places log files in a file group 😛
convinced or not, this MS url states differently:
http://technet.microsoft.com/en-us/library/cc966545.aspx
Only one file group in tempdb is allowed for data and one file group for logs.
September 29, 2011 at 11:08 am
happiestgirl (9/29/2011)
convinced or not, this MS url states differently:http://technet.microsoft.com/en-us/library/cc966545.aspx
Only one file group in tempdb is allowed for data and one file group for logs.
It's just as wrong as it was earlier. Read back a few posts.
September 29, 2011 at 11:33 am
Thanks for the question. Straight forward with something to teach. Easy if you know it, informational if you don't. Please submit more questions like this.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
September 29, 2011 at 12:40 pm
Really neat question -- thanks!
September 29, 2011 at 1:06 pm
Nice question about the basics. Thanks!
October 1, 2011 at 4:19 am
Good question.
It suggests another question: why on earth would anyone ever want more than one filegroup for tempdb?
Tom
October 2, 2011 at 7:03 am
Nice question; I should have read the "data" word after tempDB 🙂
this way I would not have selected 2 :Whistling:
Thank you,
Iulian
Viewing 15 posts - 16 through 30 (of 30 total)
You must be logged in to reply to this topic. Login to reply