SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Doubts related to file group
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

winman
Starting Member

26 Posts

Posted - 01/16/2013 :  07:18:48  Show Profile  Reply with Quote

I want to some details regarding the file groups and its use
1)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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 01/16/2013 :  11:26:53  Show Profile  Reply with Quote
quote:
Originally posted by winman


I want to some details regarding the file groups and its use
1)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 databases
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?
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000