Error trying to Restore Strataframe database


Author
Message
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
I am trying to move my app from one Machine to another. I have backed up the StrataFrame database on Machine1. When I do a restore on Machine2 I get message in SSMS:

Restore failed for Server Server2
The backup Set holds a backup of a database other than the existing 'StrataFrame' database.

The same thing happens for the StarataframeSample database. But if I backup my own database, it restores fine onto Server2. Anybody throw any light on whats happening here ?

Replies
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
The issue is that the database (StrataFrame) you are pointing to doesn't have the mappings. Most likely, this means that you have more than one SQL Server and StrataFrame database. From within Visual Studio, click the StrataFrame -> Database Connection link and make sure that you are pointing to the correct SQL Server and StrataFrame database.
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
From within Visual Studio, click the StrataFrame -> Database Connection link and make sure that you are pointing to the correct SQL Server and StrataFrame database.

Done that but still no joy. When I go into BO Mapper, each of the Business Objects sows up, but still with a red X. If I rt click and go into properties, following shows up


On New Server                On Old Srver (Working ok)
Class   SmaBO                SmaBO
Profile  ...                      ...
DataBase ...                  KFS
Table ...                       SMA
Schema ...                    dbo

Its as if it is not finding the link to the Business Objects details after I have copied to the new server and machine

Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
Just did some more digging (on the new server and machine) and notice that the table DTEProject_Item_Exceptions seems to be populated with the fileds in the Tables that make up the Busines Object and the properties seem to be set as per they should be.....so the data has definitely come over to the new macjhine and server ,just does not seem to be recognized by BO Mapper
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
Hi. Just wondering of anybody got any ideas on this... I cant copy over to our server machine and am at a standstill....TIA
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)Advanced StrataFrame User (866 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
Hi Guys....this post seems to have dropped off the raidar. I'm still unable to see the Business Objects correctly having copied over the SF database to a new server and it is really hoding me up. I would  appreciate it if any assistance could be given.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Ger Cannoll - 16 Years Ago
Michel Levy - 16 Years Ago
Ger Cannoll - 16 Years Ago
Dustin Taylor - 16 Years Ago
Ger Cannoll - 16 Years Ago
Dustin Taylor - 16 Years Ago
Ger Cannoll - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Ger Cannoll - 16 Years Ago
                         Just did some more digging (on the new server and machine) and notice...
Ger Cannoll - 16 Years Ago
                             Hi. Just wondering of anybody got any ideas on this... I cant copy...
Ger Cannoll - 16 Years Ago
                                 Hi Guys....this post seems to have dropped off the raidar. I'm still...
Ger Cannoll - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search