Timeline for SQL Server Database grew too much too fast
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 5, 2013 at 23:06 | comment | added | user507 | Try executing DBCC UPDATEUSAGE and then checking the numbers again. This command updates the catalog views: technet.microsoft.com/en-us/library/ms188414(v=sql.105).aspx | |
| Aug 5, 2013 at 15:08 | comment | added | PanosPlat | I do not know if the initial size changed, but 1306MB is the value now.sp_helpdb displays the data file size I stated.But I insist that there are not 9GB of data in that database.We have less than ten big tables, the biggest of them is 150MB and the second is far far behind. Spooky? | |
| Aug 5, 2013 at 13:26 | comment | added | user507 | So the initial size of the data file or the database is 1306MB? Is this after the restore, or after you did the shrink? If you execute "sp_helpdb 'YourDatabase', what size does it show? | |
| Aug 5, 2013 at 13:17 | comment | added | PanosPlat | Thanx for the reply Shawn. The keep the SQL code compatible with all the version of SQL Server since 2000 version. The initial size of the database is 1306MB.So the 1 to 9 ratio between backup and MDF is a bit strange, isnt it? | |
| Aug 5, 2013 at 13:09 | history | answered | user507 | CC BY-SA 3.0 |