HI All,
i have a client who is running a third party index rebuild script that runs each sunday.
the script runs fine but it create massive tlog backups, for example the logs yesterday were 14GB at 6am, 42GB at 6:30am and 7GB at 7am.
the strange thing is if i run sp_spaceused on the database it shows the index_size as being 12GB. is that all indexes in the database or do i need to run a msforeach script?
if 12GB is the size of all the indexes, then i need to figure out (with help) why the log files are so large as it is impacting on the disk they reside.
Thanks in advance,
Niall
i have a client who is running a third party index rebuild script that runs each sunday.
the script runs fine but it create massive tlog backups, for example the logs yesterday were 14GB at 6am, 42GB at 6:30am and 7GB at 7am.
the strange thing is if i run sp_spaceused on the database it shows the index_size as being 12GB. is that all indexes in the database or do i need to run a msforeach script?
if 12GB is the size of all the indexes, then i need to figure out (with help) why the log files are so large as it is impacting on the disk they reside.
Thanks in advance,
Niall