MVDBA (Mike Vessey) wrote:
when they come running for restore of a proc from a 400GB database it kinda changes their mind
Forbit them to create any table in the primary filegroup, than this is not a problem (you can do a partial restore of only one or a few filegroups, the but the [PRIMARY], where the sys tables / procedures etc. are stored, will ALWAYS be restored.
Of course it is a little bit (or on big databases much more) work to move all tables into another filegroup (by recreating any index and specifying the ON [<FG>] clausel), but in long term it helps a lot.
PS: *smart aleck on*
regarding "every Editor on this planet has File | Save" - vi or (if you like DOS more than Unix / Linux) edline have no File | Save. To be honest they have not any menue at all, since they are more commandline based editors 🙂
*smart aleck off*
God is real, unless declared integer.