Daily IT Matters, this is the place where I post my daily findings on IT.

Monday, May 19, 2008

MBSA 2.1

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.

Wednesday, May 14, 2008

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