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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2009-11-04 : 16:27:27
|
| I have a server with only 2 medium size databases but it is growing its size and have no evidence what it makes to grow.In otherwords, the Free disk space is diminishin fast.There is no adverse transactions running on the databases and no user updates or inserts are taking place.can anyone please let me know where I need to encroach into it?Thanks All. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-11-04 : 16:58:02
|
| A likely cause is that you have the databases set to full recovery and you are not running transaction log backups. This will make your transaction log keep growing.Run this script to see the size of all the database files and how much space is used in each database file:Get Server Database File Informationhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058Run this script to see how large the tables are within each database:Script to analyze table space usagehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762CODO ERGO SUM |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-11-04 : 22:28:26
|
| Neither MDF nor LDF were growing and other files were stagnant in the Disk Drive, Yet its growing in disk space consumption and leaving free space to diminish consistently.We have organised Rebooting of the server as in the past it worked for other servers and this worked but in this server.Only this server has got the secondary File NDF, is this cause any growth.Thanks for your time and answering. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-11-04 : 23:18:10
|
| The server which is growing have only one difference, which is there exists secondary data file (.NDF) extension. I have a doubt is this cause to grow any?But there is no abnormal growth in any of the data file, and no transactions going on, and no evidence for any operation being done yet decreasing in size.Any help please, thanks in advance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-11-04 : 23:59:10
|
| I dont have a clue now, anyhow Thanks |
|
|
|
|
|
|
File Size growth