By default the location is on C:\Program Files\Microsoft SQL Server\MSRS10.<<Instance Name>>\Reporting Services. Change this by modifying the rsreportserver.config file and adding the entry to the <Service> tag:

...

Thanks Gail for letting me know this feature.

As Gails Shaw advised DBCC CLEANTABLE can not help you.

DBCC CLEANTABLE reclaims space after a variable-length column ( varchar, nvarchar) is dropped.

You can just try;

1. Before truncating the table

...

If I understand your query correctly, you are asking is there possible to upgrade Active / Passive SQL Server 2005 cluster to SQL Server 2008.

Yes SQL Server 2005 cluster can...

On the simple recovery model, the transaction log is automatically truncated. If you must remove the log backup chain from a database, switch to the simple recovery model.

...

GilaMonster (8/3/2010)

---

How? Detach detaches an entire database, not a file. Same with attach....

sivaprasad (8/3/2010)

---

1. To move the file, Empty the file ,using DBCC SHRINKFILE with EMPTY option

EMPTYFILE

Migrates all data from the specified file to other files in...

No other SQL Server Instance installed

1. To move the file, Empty the file ,using DBCC SHRINKFILE with EMPTY option

EMPTYFILE

Migrates all data from the specified file to other files in the...

Query of below can help you on direction of security

set nocount on

go

--- 1. Details about the Fixed Server Roles

PRINT '1. Details about the Fixed Server Roles'

GO

sp_helpsrvrolemember

-----2. Details about the Database...

Is the login you used to install have the "Local Administrator" privileges on the the host?

Check on the setup error place on "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log"

The following are the default service on SQL Server 2008

SQL Server

SQL Server Agent

SQL Server Browser

Developer edition has the all the feature of Enterprise Edition.

However the Developer Edition has a few limitation like memory , CPU and of course limited on the license to development...

Yes, it is possible using detach and attach of database.

Please refer the KB article for details

How to move SQL Server databases to a new location by using Detach and Attach...

No, only the SQL Server 2005 Database Engine used on this single node cluster.