Shrinking the Transaction Log in SQL Server 2000

In: IT| Microsoft| SQL Server| Software

14 Jan 2010

Use the SQL Query Analyzer

BACKUP LOG XXX WITH TRUNCATE_ONLY GO DBCC SHRINKFILE(XXX_log, 10) GO

(replace XXX with the database name)

Tags: Log, Microsoft SQL Server 2000, MS SQL Server, Shrinking, SQL Server, SQL Server 2000, Transaction Log

Comment Form

Entries (RSS)
Comments (RSS)

about thomasmaurer.ch

Thomas Maurer

Thomas Maurer.
Born in 1986. live in Diegten. Switzerland. work as a System Administrator in Allschwil(Switzerland). interested in in Apple, IT, TV, Movies, Design and Art.

Follow me on twitter

Categories

Ads (1)
Fun (1)
IT (66)
- Apple (18)
  - iPhone (1)
  - Mac OS X (2)
- Google (1)
- Hardware (16)
- Hosting (5)
- HP (11)
- Microsoft (27)
  - IIS (3)
  - Office (1)
  - Sharepoint (3)
  - SQL Server (3)
  - Windows (6)
  - Windows Server (14)
    - Hyper-v (6)
    - Server Core (5)
    - Windows Server 2003 (6)
    - Windows Server 2008 (6)
    - Windows Server 2008 R2 (8)
- Software (24)
- Virtualization (9)
School (2)
Uncategorized (3)
VMware (6)
Web (16)
Work (20)

Archives

Recent Comments
Recent Posts
Tags

Joseph: I got an "Invalid Sytax" from GetObject("IIS://LocalHost/MimeMap") when running on 2008 server [...]
Cheatsheet: How to install HP Support Pack on a Server Core installation #3 | Thomas Maurer - Just another sys admin weblog: [...] Eable SNMP on Windows Server 2008 R2 Core by typing start /w ocsetup SNMP-SC [...] [...]
Carmen Cruz: BING search engine is just as good as Google. In my own personal experience, Google does give more r [...]
Marco Weber: ho no... This utility says: Smart Component execution not supported at this time in Server Vir [...]
Thomas Maurer: yeah but its really impressiv for a VM ;-) [...]