Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • Last Modified:

ReportServer database SQL2005

Hi

Is it possible to take the reportserver database off line?

thanks
0
ac_davis2002
Asked:
ac_davis2002
  • 2
  • 2
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Here is the syntax to take your ReportServer Offline

ALTER DATABASE ReportServer SET OFFLINE
GO

May I know what is the purpose you need to take it offline
0
 
ac_davis2002Author Commented:
Well, its a long story but hear goes!

I have a server that has SQL2005 installed on it. Up until yesterday I did not have any database on the server as it was purley used as a com+ server. Yesterday I created a database on the server and today i am having performace issues. I have taken the newly created databse of line but still have the problems. iput a trace on the server and I noticed the report server was creating transactions. I have stopped the report server service and wanted to take the databse off line as well to see if it made a difference.

Any thoughts on this would be appreciated!

Cheers
0
 
St3veMaxCommented:
You would need to stop the SQL Server service for you to notice any real difference; Taking the DB off-line will not make any difference unless you stop what's connecting to it to create the transactions.

If Reporting Services is on the same server; You could also stop that too.

HTH
0
 
ac_davis2002Author Commented:
cheers
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
<< I noticed the report server was creating transactions >>

Find out the reason for the transactions and resolve it out using Appropriate Query tuning or Index creations.
Taking offline wont be an appropriate step to resolve this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now