October 18, 2007 at 7:52 am
i Shrank the database through ENTMGR, and after shrinking there was no record into main transaction table , is it possible does shrinking deletes records from the tables ?
October 18, 2007 at 9:29 am
I guess shrinking wouldn't be the case here.., it may be because of a delete or truncate is got fired just after the shrink....
--Ramesh
October 18, 2007 at 9:43 am
when i used wizard option to shrink in sql 2000 it showed me that database would be shrink upto 95%, what does it mean , then after shrinking there was no record into the main transaction table
October 27, 2007 at 11:33 pm
In the shrink window, you can shrink only to the freespace percent shown. You can't go beyond the limit specified hence the commited datas to the mdf file wont be truncated or deleted.
But if you have some open transactions and if it is uncommited and if you run the below query
backup log dbname with truncate_only
It will washout all the uncommited transactions in the log file.
You can refer to the below link
How to avoid using shrink in SQL Server 2005?
Here's a good reason not to run SHRINKDATABASE
Why you want to be restrictive with shrink of database files
Regards..Vidhya Sagar
SQL-Articles
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply