Wednesday, 15 April 2015

sql server - Large table with no rows? -


I have a SQL Server 2005 database that includes several tables in large amounts (more than 10 GB), and these They do not have any row in the tables. I can see location and line count with right-click, properties (data space and line count items).

Any thoughts?

The transaction log and data file is not deleted when the data is removed, the notion that you ' You will use it again if you really need it, you can use DBCC SHRINKFILE and / or DBCC SHRINKDATABASE to retrieve it.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)