We help IT Professionals succeed at work.

Project Server 2003: Does the SQL server analysis cube need to be backed up daily, if yes how?

Medium Priority
413 Views
Last Modified: 2013-11-15
I have a project server 2003 instance running. I backup the SQL server database every night. I have noticed that project server also uses SQL server analysis services as well and has a cube. Does this cube need to be backed up or can it be re-created from the project server database?

If it does need to be backed up, how can this be automated?

Thanks Experts!
Comment
Watch Question

Commented:
The cube does not need to be backed up and is created from the other databases on a regular schedule. (In PWA, see Server Settings -> Cube section -> Build Settings)

Depending on how Analysis Services was installed, it may create a SQL database often called "Analysis Services Repository" This database may be backed up, but is not critical if only supporting the Project Server Cubes. A new repository can be made and the cubes rebuilt.


Hope this helps...
James Fraser
sqlagent007Technology professional

Author

Commented:
This helps very much, thank you.

So in the event of a complete disaster and I need to rebuild, the only think I need is the SQL2000 database "ProjectServer"?

The rest can be re-built from that database?

Again, thanks for your help!

Commented:
If you are not using Windows Sharepoint Services (also known as WSS or "Project Workspaces"). WSS creates two databases that should be backed up: WSS_Config and WSS_Content.


James Fraser
Hello sqlagent007,

James is correct.

I will add that in Project Server 2003 every time you update the cube, the existing cube is completely overwritten.  You can use the SQL 2000 Analysis Manager to delete the cube completely and Project Server will rebuild it from scratch.  If you change (or miss-type) the name of the cube in the PWA Admin area, a new cube will be created with the new name.

This why you can't really get away with making changes to the Project Server cube with the Analysis Manager tool.  Your changes will get deleted or disconnected during the next Project Server cube update cycle.

Bob Segrest, PMP
MCITP, Microsoft Project Blackbelt
sqlagent007Technology professional

Author

Commented:
Great! I have been backing the 2 sharepoint databases and the "ProjectServer" database every night. I just wanted to make sure I have everything I need in the event of a disaster.

Will I be able to recover everything from those 3 backups?

thank you....
Commented:
Yes. You should be able to recover everything from those. Recovering ProjectServer is not difficult. Recovering the SharePoint site and data can be more involved.

Make sure that you know the updates/patches/service packs appliedd to everything. If you need to restore, you should make sure that all software is patched to the same level.


James Fraser

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.