Wednesday, June 20, 2012

Moving tempdb on SQL 2008 R2

Moving tempdb to a new location:

1) Connect to the SQL server and run this query:
USE master
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = '[new path]\tempdb.mdf');GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = '[new path]\templog.ldf');GO

2) Stop the SQL service
3) Move tempdb.mdf and templog.ldf to the new location
4) Start the SQL Service

Tuesday, June 19, 2012

Using Microsoft SQL Report Builder 3 to create custom SCOM 2007 R2 reports

In SCOM 2007 R2 if you click "Design a new report" from the Reporting tab you will notice that Report Builder version 1 runs, even if you have version 3 installed because SCOM still opens the old link.
To use 3 instead navigate to the C:\Program Files\Microsoft SQL Server\MSRS10_50.SCOM\Reporting Services\ReportServer\ReportBuilder

Make a copy of "ReportBuilder_3_0_0_0.application"

Rename "ReportBuilder.application"

Rename the copy of version 3 to "ReportBuilder.application"

Now when you "Design a new report", SCOM will run Report Builder 3.