Moving the ReportServer database

I want to move the ReportServer database .mdf and .ldf files from the default directory to another drive (E:)

The ReportServer service is started, but when I run a sp_help_db from SQL Server management studio the ReportServer database is not listed. When I tried to detach it using sp_detach_db , the command reported succes but I'm wondering how this worked when the database is not in the sysdatabases table.

I haven't tried moving the ReportServerTempdb but I imagine that this would be ok, because this is in sysdatabases.

I can't seem to find anything in BOL about moving just the ReportServer database itself , anyone else come across this?

Thanks!

sp_helpdb will only return databases you have access to, so that may be part of it...also won't return databases that are offline and some other things, so not sure if that might be what you are seeing....

As for moving the database files, the RS catalog DB and RSTempDB's are just like any other user database, you can move the data files wherever you like, so long as SQL Server can see them. Note that the ReportServer service does not necessarily have to be running in order to see/move/modify/etc. the RS databases in SQL Server. The ReportServer service is simply a consumer of the SQL Server services to provide data storage in the RS and RSTempDB databases, that's all.

HTH,

|||

Thanks.

I'm using the sa login, so I would expect to be able to see it. There is nothing in sys.master_files for the ReportServer database and it does not show up in the list of databases in the management studio.

I haven't actually configured Reporting Services yet, only installed it. Is it possible that the database is not listed or attached until reporting services is up and running?

Cheers