the usedPages value is very large...estimatedpages is very slow....
but not shrinking....|||
check of any open transaction . DBCC Opentran
Madhu
|||thnxI run and and this is the result:
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (4990:4944:1)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
What can i do with this?|||
From BOL
If neither database_name nor database_id is specified, the default is the current database.
Use DBCC OPENTRAN to determine whether an open transaction exists within the log. When using the BACKUP LOG statement, only the inactive portion of the log can be truncated; an open transaction can cause the log to not truncate completely. In earlier versions of Microsoft? SQL Server?, either all users had to log off or the server had to be shut down and restarted to clear uncommitted transactions from the log. With DBCC OPENTRAN, an open transaction can be identified (by obtaining the system process ID from the sp_who output) and terminated, if necessary.
you need to termintate this open transaction
http://msdn2.microsoft.com/en-us/library/ms182792.aspx
http://www.sql-server-performance.com/dbcc_commands.asp
google it you will fine many
Madhu
|||I stopped the replication (snapshot) and after I could shrink the log....So this is a bug? ( the db running without any sp)
I tried....I re-set the replication and the symptom is occurred again....
so when I set a replication on this db, I can't shrink the transaction log anymore...
No comments:
Post a Comment