Restore Reportserver database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Restore Reportserver database

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-12-29 : 14:59:09

I need to restore ReportServer database in another server. As far I know it's not like normal backup and restore method. Please advice the steps to how to restore it ? Thank you!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-29 : 15:02:57

2 seconds of googling brought me to this: http://technet.microsoft.com/en-us/library/ms156421.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-12-29 : 15:25:14

I am moving reportserver database from one server to other server(already reporting services installed and reportserver db is there)

I am planning to below steps

1. Stop report server
2.detach database in primary server
3.copy mdf and ldf file to secondary server
4 attach the database
5.start report server.

One question I have already reportserver db in secondary server. any otherthings to take care

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-29 : 15:50:56

Whatever that link says is what you need to do.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources