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 |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2007-11-03 : 21:30:27
|
| I am looking to find out when to use file groups when backing up. When should you use this, what's the benefit over just doing a full db backup? Is it better when you are dealing with large db's?Also this question has been on my mind for a while. Why shouldn't you shrink the db after every full backup? What is the negative in doing so?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-03 : 21:44:30
|
| For the first part...there is information on the sql-server-performance.com web site. Find the article that deals with performance of backups.For the second part...you shouldn't shrink either the MDF or the LDF after maintenance, backups, or whatever unless you know that the database no longer needs this space in the near future. You are receiving a huge performance penalty when the database has to grow the file since you shrunk it down. Why bother shrinking something that is needed? Typically the only time that you shrink is when you had a one-off process run that used up a lot of the transaction log and didn't do it in batches. Since you know the process is a one-off and therefore will not be run again, you can shrink the file down to the size that it was before it ran. Another example of when to shrink is when you purge lots of data and that size is no longer needed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
File Groups