2

I don't understand about the purpose of using Filegroup in SQL server? What benefit can it provide?

HelloWorld1
  • 13,688
  • 28
  • 82
  • 145

1 Answers1

1

If you're using Enterprise Edition, you can do a piecemeal restore. That is, you can place critical and not-so-critical tables on different filegroups and, in the case of disaster, recover them at different times. This requires a lot of forethought, but is handy.

Ben Thul
  • 31,080
  • 4
  • 45
  • 68