Note: The new SQL server and Reporting server must meet the requirements listed in SAV reporting installation guide.
Detach the Reporting database
If you are using SQL 2000, detach through SQL 2000 Enterprise Manager. If you are using SQL 2005, detach through SQL Server Management Studio.
After the Database is detached, navigate to the appropriate data folder where the existing SQL server data files are stored - e.g. C:\Program Files\Microsoft SQL Server\MSSQL\xxxx\DATA OR C:\Program Files\Microsoft SQL Server\MSSQL\DATA.
Copy the following database files to the data folder for the new server housing your new SQL DB
The File names for the database files would be - <Reporting.mdf; and Reporting_log.ldf>
On the new server where you want to move the existing SQL DB for Reporting Server, Right click on the Database instance, and click on Tasks / All Tasks and click on ATTACH DATABASE.
Give the path to the <db_name.MDF> file, and the wizard shall automatically pick up the other .NDF and .LDF files.
Reinstall reporting server pointing to the new SQL server.
Note: When installing, it is not necessary to specify the reporting instance since it is already in the SQL database. Specifying the reporting database instance may cause the install to fail.