Posts

Showing posts from May, 2008

MBSA 2.1

Image
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.

Restore failed for Server 'SERVER\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

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.