November 2007 - Posts

The SQL 2005 September 2007 BOL update is now (finally since it's almost December!) available for download. You can download it from the link below

 

Posted by sqldbatips | 1 comment(s)
Filed under: ,

New versions of SQL 2005 Service Manager are now available for WinXP/Win2003/Win2008 and Vista. The only changes in these new releases are the addition of SQL 2008 support and Windows 2008 support for the non Vista version. As it turned out, adding SQL 2008 compatability only required a single line to be changed (and it could be argued that was a bug!). Download links below as well as the link to the Codeplex site where you can download the source code.

 

Posted by sqldbatips | with no comments
Filed under: ,

I got a question recently asking if it is possible using the Expressmaint utility to perform an integrity check of a database and then do a full backup only if there were no errors reported from the integrity check. Although there is no built in functionality for this, it's very easy to automate using a simple batch file as demonstrated below

:: Check Integrity and only backup if ok
@echo off
SET DBNAME=master
SET INSTANCE=(local)\SQLExpress
SET BACKUPFOLDER=C:\backups
SET REPORTFOLDER=C:\reports

expressmaint -S %INSTANCE% -D %DBNAME% -T CHECKDB -R %REPORTFOLDER% -RU DAYS -RV 7

IF %ERRORLEVEL% EQU 0 (
expressmaint -S %INSTANCE% -D %DBNAME% -T DB -B %BACKUPFOLDER% -BU DAYS -BV 2 -R %REPORTFOLDER% -RU DAYS -RV 7
) ELSE (
echo CheckDB finished unsuccessfully so no backup done
)

As you can see, we run an integrity check and only if the return code is 0 (i.e. no errors reported) is the full backup performed. Using simple batch files or scripting, it's easy to customise how the utility works to suit your environment. And if you're feeling adventurous, you can always download the source code from Codeplex and customise it yourself!

Posted by sqldbatips | 1 comment(s)
Filed under:

The November CTP of SQL Server 2008 is now available for download at the link below

There's a lot of new functionality and features in this latest CTP including (but not limited to)

  • Backup Compression
  • Resource Governor
  • TSQL Intellisense (well sort of Smile)
  • Data collection and Performance Warehouse improvements
  • Transparent Database Encryption
  • Filestream
  • Geospatial support
  • Change Tracking
  • Declarative Management Framework enhancements
  • Configuration Servers

 

Posted by sqldbatips | with no comments
Filed under: ,