Task 9: Simple Q&A

• I have a direct relationship with my clients and we're frequently confronted with interesting Q&A. For this task I'll update the questions and answers in progress. 

1Q. In order to move the DataWarehouse from production to development server, can we just move the DataMart.mdf, DataVault.mdf , StagingArea.mdf and the log files *.ldf from one server to another?

1A. It’s not so easy to move the data from one server to another.

We need to back-up all databases from production server and restore them to the development one. Or use attach-detach commands for the same scope. We also need to pay attention on disk space for back-up and also to the VPN connection between user and servers.

2Q. The back-up should be placed on development server Local Disk(U:). This is a disk that’s not “snapshotted”.On production server you can map to this disk. Before starting the restore on development server we have to stop “snapshot”. Can we do in this way the back up procedure?

2A. I’m afraid this option could not be possible because the database back-up can be done only on local disks, not shared or mapped one. We need a disk with sufficient space for back-up directly on production server because the mapped disk does not appear in backup location list.

Restore database backup over the network

SQL Server backup across the network

3Q. How to resolve the error received  while processing a cube using the BIDS (Business Intelligence Development Studio) : "The following system error occurred: The trust relationship between the primary domain and the trusted domain failed." 

3A. This error occurred during cube processing might occur because of inapprotiate role definitions between the development and the target deployment environments of SSAS applications.  Drill down to the Roles folder in the Solution Explorer of the SSAS database solution. A list of roles will be listed under the Roles folder as seen in the following screenshot. 

If you double-click the role definition and navigate to the Membership tab in the role definition screen, you will see a list of users and groups assigned for this role. These assigned users and members of these assigned groups have the privileges and required permissions in all of the SQL Server Analysis Services objects within the SSAS database.  If you remove the user or the user group that is defined for the SSAS role object using the Remove button, you can handle this error and finish the deployment and so the process of the cube successfully.