 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008how to make the database size smaller?
my database is 9G! I try to truncate some table to make the database smaller but it seems it doesn't help, the database size has not changed by truncate some table, so is there any good method to make the database size smaller? (I accept some data loss in some table)!! Are you backing up this database? I would run a transaction log backup and truncate the log when you do. After that you should be able to shrink the database and remove unused space.  Signature~lb > my database is 9G! I try to truncate some table to make the database smaller > but it seems it doesn't help, the database size has not changed by truncate > some table, so is there any good method to make the database size smaller? (I > accept some data loss in some table)!! how to truncate the log? anyway, the data file type is already 9G. > Are you backing up this database? > I would run a transaction log backup and truncate the log when you do. [quoted text clipped - 4 lines] > > some table, so is there any good method to make the database size smaller? (I > > accept some data loss in some table)!! I would look at Books Online for more info - check backup log... Run this code if you want to truncate the transaction log and not keep a backup of the transaction log. Truncate_only invalidates your transaction log backup sequence. Take a full backup of your database after you perform backup log with truncate_only: BACKUP LOG YOURDATABASE WITH TRUNCATE_ONLY Signature~lb > how to truncate the log? > anyway, the data file type is already 9G. [quoted text clipped - 7 lines] > > > some table, so is there any good method to make the database size smaller? (I > > > accept some data loss in some table)!! I suggest you read about the DBCC SHRINKFILE command. SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > my database is 9G! I try to truncate some table to make the database smaller > but it seems it doesn't help, the database size has not changed by truncate > some table, so is there any good method to make the database size smaller? (I > accept some data loss in some table)!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.