Archive for the ‘SQL Server’ Category
How to integrate (slipstream) SQL Server 2008 and SP1
In: IT| Microsoft| SQL Server| Software| Windows Server 2008 R2| Work
11 Feb 2010 var fbShare = {url: ‘http://www.thomasmaurer.ch/2010/02/how-to-integrate-slipstream-sql-server-2008-and-sp1/’,size:’small’} To install SQL Server 2008 on a Windows Server 2008 R2 you need a slipstream version of SQL Server 2008 with integrated Servicepack 1. At the moment you can’t download SQL Server 2008 with integrated SP1, so you have to create your own slipstream version.
1. Copy your original SQL [...]
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
