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 |
|
winman
Starting Member
26 Posts |
 Posted - 2013-01-16 : 07:18:48
|
| I want to some details regarding the file groups and its use1)Does creating the file group requires extra work and effort while doing backup and restore?2)Does the file group can be used to increase the performance of sql server if database size is around 2 to 5 Gb? Or file group are only necessary if size is so large?3)Can i backup and restore each file group separately.? Can i restore only secondary file group without restoring primary?4)Can ldf files have file group? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2013-01-16 : 11:26:53
|
quote:
Originally posted by winman
I want to some details regarding the file groups and its use1)Does creating the file group requires extra work and effort while doing backup and restore?Not an issue if you are doing full backup and restore. you can do filegroup backup/restore for huge databases2)Does the file group can be used to increase the performance of sql server if database size is around 2 to 5 Gb? Or file group are only necessary if size is so large?Yes if they are placed on different drive which you can separate read vs write. I wouldn't suggest filegroup for 2 to 5 GB.3)Can i backup and restore each file group separately.? Can i restore only secondary file group without restoring primary?Yes you can . I think you will need to restore Primary also4)Can ldf files have file group?Yes but you don't need FG for log file. It is fill as you go.
|
 |
|
|
|
|
|
Doubts related to file group