Daily IT Matters [DIM]

Microsoft released their Baseline Security Analyzer tool version 2.1. This tools can scan your own pc or another pc remotely for misconfiguration, updates and things like weak passwords.   For a serious sysadmin this tool is invaluable.

TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore failed for Server 'SERVER\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'DEVELOP' database. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ I had the above message when I tried to restore a backup. The solution is simple. In the options pane, just select overwrite the existing database thats it.