For content related to previous versions of SQL Server, see bcp Utility. For the syntax conventions that are used for the bcp syntax, see TransactSQL Syntax. This topic covers the main Oracle SQL Developer concepts, and explains how to use the major SQL Developer features. As SQL Server database development is a good candidate for code documentation, this development workflow applies and this article will focus on following steps. How do I shrink my SQL Server Database This is an old question but I just happened upon it. The really short and a correct answer is already given and has the most votes. That is how you shrink a transaction log, and that was probably the OPs problem. And when the transaction log has grown out of control, it often needs to be shrunk back, but care should be taken to prevent future situations of a log growing out of control. This question on dba. Basically Dont let it get that large in the first place through proper recovery model, transaction log maintenance, transaction management, etc. Microsoft Sql Server Transaction Log Truncate Meaning' title='Microsoft Sql Server Transaction Log Truncate Meaning' />But the bigger question in my mind when reading this question about shrinking the data file or even the log file is why It appears as though shrink operations were done. Now in this case it makes sense in a sense because MSDEExpress editions are capped at max DB size. But the right answer may be to look at the right version for your needs. And if you stumble upon this question looking to shrink your production database and this isnt the reason why, you should ask yourself the whyI dont want someone searching the web for how to shrink a database coming across this and thinking it is a cool or acceptable thing to do. Shrinking Data Files is a special task that should be reserved for special occasions. Consider that when you shrink a database, you are effectively fragmenting your indexes. Consider that when you shrink a database you are taking away the free space that a database may someday grow right back into effectively wasting your time and incurring the performance hit of a shrink operation only to see the DB grow again. Microsoft Sql Server Transaction Log Truncate Meaning' title='Microsoft Sql Server Transaction Log Truncate Meaning' />What version of SQL Server do I have This unofficial build chart lists all of the known Service Packs SP, Cumulative Updates CU, patches, hotfixes and other. Backup Databases from SharePoint 2010 SQL Server Login to SQL Server box of your SharePoint 2010 Farm Open SQL Server Management Studio, Expand Databases node. I wrote about this concept in several blog posts about shrinking databases. Codigo Para Renovar Norton Internet Security. This one called Dont touch that shrink button comes to mind first. I talk about these concepts outlined here but also the concept of Right Sizing your database. It is far better to decide what your database size needs to be, plan for future growth and allocate it to that amount. With Instant File Initialization available in SQL Server 2. I still prefer to have a proper initial application and Im far less scared of white space in a database than I am of shrinking in general with no thought first. Microsoft Sql Server Transaction Log Truncate Meaning' title='Microsoft Sql Server Transaction Log Truncate Meaning' />Using the Teradata JDBC Driver. This chapter describes using the Teradata JDBC Driver software in Java programs, and guides you through the process of getting.