Re: HELP!!
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 04/14/04
- Next message: Russell White: "Users in database have no associated login"
- Previous message: DAVE: "HELP!!"
- In reply to: DAVE: "HELP!!"
- Next in thread: Hari: "Re: HELP!!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 14 Apr 2004 19:21:49 +0100
You can use DBCC SHRINKFILE. See BOL for syntax plus look at
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318
INF: Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110139
INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317375
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "DAVE" <anonymous@discussions.microsoft.com> wrote in message news:64DAA4E3-173F-43B6-A12A-104336227E8A@microsoft.com... > how do i reduce the size of an mdf and ldf file in sql server2000. they have grown to the point of locking up my machine
- Next message: Russell White: "Users in database have no associated login"
- Previous message: DAVE: "HELP!!"
- In reply to: DAVE: "HELP!!"
- Next in thread: Hari: "Re: HELP!!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
