Posts Tagged ‘Log’
Shrinking the Transaction Log in SQL Server 2005
In: IT| Microsoft| SQL Server| Software
14 Jan 2010var fbShare = {url: ‘http://www.thomasmaurer.ch/2010/01/shrinking-the-transaction-log-in-sql-server-2005/’,size:’small’}
Use the MS SQL Server Management Studio
EXEC sp_dboption ‘XXX’, ‘trunc. log on chkpt.’, ‘TRUE’
CHECKPOINT
DBCC SHRINKFILE (‘XXX_Log’, TRUNCATEONLY)
EXEC sp_dboption ‘XXX’, ‘trunc. log on chkpt.’, ‘FALSE’
GO
(replace XXX with the database name)
Shrinking the Transaction Log in SQL Server 2000
In: IT| Microsoft| SQL Server| Software
14 Jan 2010var fbShare = {url: ‘http://www.thomasmaurer.ch/2010/01/shrinking-the-transaction-log-in-sql-server-2000/’,size:’small’}
Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO
(replace XXX with the database name)
about thomasmaurer.ch
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.
Categories
- Ads (1)
- Fun (1)
- IT (66)
- Apple (18)
- 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)
- 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 ;-) [...]
- Active Directory Schema Versions
- Cheatsheet: Using Diskpart on a Server Core installation #4
- Cheatsheet: How to install HP Support Pack on a Server Core installation #3
- Cheatsheet: Add roles and features to a Server Core installation #2
- Cheatsheet: Configuring a Server Core installation #1
- How to create a Windows 7 & Windows Server 2008 R2 Install USB Stick
- Sharepoint 2007 or WSS 3.0 export/import
- How to integrate (slipstream) SQL Server 2008 and SP1
- The Bing Bang Theory: Windows 7 is much more userfriendly than Windows Vista
- Configuring IIS for Silverlight Applications
Latest Photos
