.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

How to Remove database Size in SQL Server 2005

Posted By: kamlesh     Posted Date: June 06, 2011    Points:5   Category :Sql Server
hi..
i have database when i fire the script for that database the size of that is 70,058 KB and when i store the data size is suppose 2,00,000 KB and when i truncate or delete the data or itoms from database so it should decrease the size of database but it shows same size (2,00,000 KB). so how to decrease the Size of database after delete items from That Database . please Help me..

Responses
Author: Gowthammanju             
Posted Date: June 06, 2011     Points: 20   

Hey dude!

I want to know that how you have created the database!

through
1) writing the query
r else
2)just right click the database and create new table......


while u r creating the tables u might be mentioned the size for each fields such as

example:s.no varchar(500)...etc

just reduce that space in each fields den only u will able to reduce the database total size

if u did not mention the size den mention to each fields since it takes the full byte value!



Thanks & Regards,
GowthamManju
Chennai



Mark if the answer is true
Author: Sasi Prabhu             
Posted Date: June 06, 2011     Points: 20   

Refer :

http://www.beyondweblogs.com/post/SQL-Server-2005-Shrink-and-Truncate-Log-file-size.aspx

Thanks & Regards,
Sasi Prabhu.


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend