Tom's blog

Thoughts about SQL and related stuff…

Entries for June, 2011

Error “System Assertion Check has failed” Msg 3624, Level 17, State 1 when trying to do a log restore with the STOPATMARK option in SQL 2008

Jun.23, 2011 in SQL 3 Comments

Recently our operational team had to do a restore of a database for BizTalk. These databases require a special restore routine, to let the BizTalk components in sync with the DB. First they restored the latest full backup, which went without problems. Then they needed to restore the transaction log backups, with the STOPATMARK option [...]

Tags: , , , ,

New cumulative update packs for SQL 2008 SP1 and SP2

Jun.01, 2011 in SQL, SQL Updates & Service Packs Leave a Comment

Microsoft recently released two new cumulative updates: CU14 for SQL 2008 SP1 and CU4 for SQL 2008 SP2. This makes following build table: Version Service Pack (SP) / Cumulative Update (CU) 10.50.1777.0 R2 CU7 10.50.1765.0 R2 CU6 10.50.1753.0 R2 CU5 10.50.1746.0 R2 CU4 10.50.1734.0 R2 CU3 10.50.1720.0 R2 CU2 10.50.1702.0 R2 CU1 10.50.1600.1 SQL 2008 [...]

Tags: , , , ,