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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-04-30 : 15:42:06
|
| In what scenario – diff and full backups have same size? My guess is excessive fragmentation, any thoughts?------------------------I think, therefore I am - Rene Descartes |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-04-30 : 15:45:36
|
| One likely cause is that you have reindexed all the tables with a maintenance plan since the last full backup.If you are going to use diff backups, you should schedule your full backup to run after any reindexing operations.CODO ERGO SUM |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-30 : 15:52:15
|
| That may be the case. We do reindexing in MP after the FULL backup. I will check and comeback.------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-30 : 15:54:52
|
| Does the maintenance plans reindex only those indexes that are fragmented or does it do the same thing it did in 2000 when it did all of them?If the MP reindexes everything, then you should consider not doing that and instead use a script such as mine (isp_ALTER_INDEX). Check my sig for the link.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-30 : 15:59:36
|
| Thanks Tara. We are doing a 2000 type of reindex. Tara, I will check your scripts. Thanks again.------------------------I think, therefore I am - Rene Descartes |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-04-30 : 16:08:14
|
| You should still schedule the full backup after the reindex operations to reduce the size of the diff backups, even if you only do a partial reindex.CODO ERGO SUM |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-30 : 16:13:36
|
| Yes. Got your point. Thanks MVJ! Your posts always are very helpful! Saved my life couple of times.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Diff and full backups have same size!