The below syntax will allow you to shrink a SQL Server Database Data File and Transaction Log File — Truncate the log BACKUP LOG biztalkdtadb WITH TRUNCATE_ONLY — Shrink Log File dbcc shrinkdatabase (BizTalkDTADb, 10) – Shrink Data File dbcc shrinkdatabase (BizTalkDTADb_log, 10)
Tag Archive: SQL Server
Permanent link to this article: http://www.tsls.co.uk/index.php/2009/05/13/shrink-sql-server-data-and-log-files/
Sep
03
Quest Tools
LiteSpeed – for SQL Server ———————————- In summary LiteSpeed is a backup utility. This backup tool is being used by Microsoft and some of the leading banks to backup there SQL Server. This backup utility has the ability to improve backup and restore times by up to 70% faster and will compress the data up …
Permanent link to this article: http://www.tsls.co.uk/index.php/2008/09/03/quest-tools/
Sharepoint Alertz
- SharePoint 2007: A user's presence information does not appear correctly in People search results intermittently
- Description of the Office SharePoint Server 2007 hotfix package (coreserver-x-none.msp): October 26, 2010
- Description of the Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): October 26, 2010
BBC News
- More floods threaten Queensland February 6, 2012Floods continues to threaten Queensland in eastern Australia, with 3,000 evacuated and the town of St George expecting to be worst affected. […]
- Giants edge Patriots in stunner February 6, 2012Eli Manning produces yet another ice-cool performance in the fourth quarter as the New York Giants come from behind to beat the New England Patriots 21-17. […]
- Businesses 'cautious' on future February 6, 2012UK firms plan to cut back on capital investment and hiring as the UK economic outlook remains gloomy, a report suggests. […]
- MPs fear far-right terror threat February 6, 2012MPs have warned the government not to neglect the threat from extreme far-right terrorism, saying […]