45 reputation
7
bio website
location
age
visits member for 1 year, 6 months
seen May 24 at 9:57

1d
awarded  Popular Question
Apr
9
awarded  Popular Question
Aug
5
comment SQL Server Database grew too much too fast
Thanx Kenneth..nothing unusual in the output :( Check the UPDATE2 in my original post btw
Aug
5
awarded  Commentator
Aug
5
revised SQL Server Database grew too much too fast
added 160 characters in body
Aug
5
comment SQL Server Database grew too much too fast
I will update the original post, to give the sp output
Aug
5
comment SQL Server Database grew too much too fast
Thank you Kenneth. I will try your suggestion when the customer closes for the day. Question:If I DROP and then CREATE all indeces again will it be better? The excessive data was not due to the "migration".I checked the SQL Server 2000 MDF and it was at 9GB. Something must have happened during the last two months and I am trying to find out.
Aug
5
comment SQL Server Database grew too much too fast
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
revised SQL Server Database grew too much too fast
added 58 characters in body
Aug
5
comment SQL Server Database grew too much too fast
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
asked SQL Server Database grew too much too fast
Mar
18
comment SQL Server 2005 encryption - What Grants should I give
Briliant! Thanx!
Mar
18
accepted SQL Server 2005 encryption - What Grants should I give
Mar
17
asked SQL Server 2005 encryption - What Grants should I give
Mar
17
awarded  Scholar
Mar
17
comment SQL Server 2005 encrypted database works on new PC without restore keys!
Thanx a lot Remus!
Mar
17
accepted SQL Server 2005 encrypted database works on new PC without restore keys!
Mar
17
asked SQL Server 2005 encrypted database works on new PC without restore keys!
Feb
20
awarded  Supporter
Feb
20
comment SQL Server 2005 database corruption. Advise
Thanx Sebastian! I took a full copy-only backup but it cannot be restored. Tommorow in the office I will try the Data Compare thing.