Microsoft KB Archive/927959
Article ID: 927959
Article Last Modified on 11/20/2006
- ProClarity Analytic Server
In ProClarity Analytics Server, you can store a personal collection of views in a Microsoft SQL Server database. Best practices dictate that you should regularly back up this SQL Server database. When you do this, you can restore the personal collection from the database backup if the personal collection becomes incorrect. This article describes how to restore the My Views collection from a SQL Server backup.
To restore the My Views collection for a user from a SQL Server backup, follow these steps.
Note If you are using SQL Server 2000, open Query Analyzer. If you are using SQL Server 2005, open SQL Server Management Studio.
The Users table stores the link to each user's My Views collection. The FavoritesID column is the identifier of the My Views collection. To find the identifier for a user's My Views collection, use Query Analyzer or Management Studio to connect to the instance of SQL Server that contains the backup database. Then, run the following query:
SELECT * FROM Users
- Find the row that has the user's name in the Username column, and then note the value in the FavoritesID column for that row.
To identify the collection of views for the user, run the following query by using the value that you noted in step 2:
SELECT * FROM Books WHERE BookID = '<FavoritesID>'
To identify the individual views for the user, run the following query against the BookElements table by using the value that you noted in step 2:
SELECT * FROM BookElements WHERE BookID = '<FavoritesID>'
The result set contains all individual views that were included in the My Views collection for the user the last time that the database was backed up.
At this point, you may decide to restore an individual record or a group of records to the production database. However, you must make sure that the FavoritesID column in the Users table matches the BookID column in both the Books table and the BookElements table. Otherwise, the user will not see the views the next time that the user logs on to the server.
In some cases, you may want to restore the whole SQL Server database or an individual table in the SQL Server database. Before you do this, you must be aware that this action will remove content that has been added to ProClarity Analytics Server since the last time that the SQL Server database was backed up. Again, you must make sure that the FavoritesID column in the Users table matches the BookID column in both the Books table and the BookElements table.
Additionally, after you restore the database or the table, the user may not see the views the next time that the user logs on to the server. If the user cannot see the views, check the Users table. Notice whether the user is listed two times with different Security Identification (SID) values in the UserID column. If the user is listed two times, make sure that the valid record has the correct FavoritesID value in both the Books table and the BookElements table. The valid record is the most recent record based on the value in the CreatedTime column. The correct FavoritesID value is the value for the collection that the user is trying to access.
Keywords: kbhowto KB927959