Delete transaction log from SQL server 7.0

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.1
Delete transaction log from SQL server 7.0

ASP.NET 1.1 As of 10/6/2005, this forum is locked as part of the reorganization described here: http://p2p.wrox.com/topic.asp?TOPIC_ID=35394. No posts have been deleted. Open ongoing discussions from the last week have been moved to either ASP.NET 1.0 and 1.1 Beginners http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/ or ASP.NET 1.0 and 1.1 Professional. http://p2p.wrox.com/forum.asp?FORUM_ID=50. See my sticky post inside for more.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.1 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 19th, 2005, 05:41 AM

bdnagesh

Authorized User

Join Date: Dec 2004

Posts: 27

Thanks: 0

Thanked 0 Times in 0 Posts

Delete transaction log from SQL server 7.0

Hi,
In our SQL server one of the databases is occupying 500MB of space for transaction log. I want to clear up the space. I have used DUMP tran DBNAME with no_log but still I see the same size. All I want to do is get more space after clearing up transaction log for that perticual database. Please help.

bdl

__________________
bdl

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transaction log	carumuga	SQL Server 2005	0	August 7th, 2008 05:38 AM
Truncating Transaction Log	sgsandeep	SQL Server 2000	2	July 11th, 2006 08:51 AM
use of transaction log	madhukp	SQL Server 2000	1	July 16th, 2004 06:20 PM
log and transaction issue	ak	SQL Server 2000	0	September 29th, 2003 06:32 AM
Transaction Log	ColdFusionRO	SQL Server 2000	3	July 16th, 2003 01:47 PM