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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Backup Report Server Reports

Author  Topic 

mchohan
Starting Member

39 Posts

Posted - 2010-02-16 : 05:26:11
Hi,
I'm not sure what I need to backup regarding my report server enviroment. Here is the setup.

Local Dev PC: I have created a few Report Models which sits above the database layer. I need to know what I should backup here? Is the actual Visual studio project enough for this?

Live Server: I have publised the above Report Models to the live server. On this live server, various people have created reports using Report Builder. I want to back up these reports. What do i need to back up and how?

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-02-16 : 15:30:22
Backup the rdl files to another server, tape, or some form of media. Backup the ReportServer database in SQL Server.

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."
Go to Top of Page

mchohan
Starting Member

39 Posts

Posted - 2010-02-17 : 06:56:20
Hi,
Thanks, The Reports have been created via Report Builder, not Visual Studio SSRS. Therefore, I don't know where or if rdl files exist?
Go to Top of Page
   

- Advertisement -