Database version 2000 SP 4
Database size : 100 GB , Transaction Log 200: GB , Recovery mode: Simple
I am trying to shrink the transaction log and every time I go to options, it gives me a bigger size to shrink to than the existing log size on the EM. There was replication setup on this database and i removed all the articles and restarted Sql server and the server itself as well.
The database backup works fine.
Please let me know how to fix this issue.
thanks,
Mark.
Hi,http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html
HTh, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment