[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

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

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!
0
sqlagent007
Asked:
sqlagent007
  • 3
  • 2
1 Solution
 
jbfraserCommented:
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
0
 
sqlagent007Author 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!
0
 
jbfraserCommented:
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
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
bobsegrestCommented:
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
0
 
sqlagent007Author 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....
0
 
jbfraserCommented:
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
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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