Re: Supporting SP1 and SP2 Databases

Tim,

That should work.
Btw, replace both MantisSQLDB_Data.mdf (the database) and MantisSQLDB_Log.ldf (transaction log) files.

But keep in mind that you are using the same Repository locations for both SPs in your scenario. Not a big deal since the SP2 update
repository is separate from SP1. But again, may be a little bit risky when it comes to installing various QFEs (needs to be tested
well, I guess).
Or you can also have two separate physical Repositories on the drive. All you have to do during switch then is to change the network
share target (default repository share name is Repositories).

--
Regards,
KM


> KM,
>
> What if I install the sp1 compoent database, stop service and rename
> database, install component database again with sp2. if i need to access the
> sp1 database, stop service, rename sp2 database and then rename sp1 database
> to mantis?
>
> "KM" wrote:
>
>> Tim,
>>
>> There is currently no way to support XPe SP1 and SP2 database running the same time on the same server [dev] machine.
>> This is what I outlined in my reply to your previous post.
>>
>> But you can go by one of the following routes:
>> - Have two server machines running each database separately. Then on dev machines it is easy to switch between databases and
>> repositories.
>> - Detach database of fly (use osql utility or SQL Enterprise Manager or just stop MSDE service with sc.exe or "net stop
>> MSSQLSERVER" command)
>> replace the Mantis LDF file under the \Windows Embedded Data folder on the server and attach to the database again.
>> - Have only SP2 server machine running. You can still build and support SP1 images. (a little bit risky when it comes to SP1
>> QFEs)
>>
>> --
>> Regards,
>> KM
>>
>>
>> > Microsoft states you should use 2 separate machines, one for maintaining SP1
>> > builds and another for SP2 builds. This sounds like this could be a
>> > maintenance nightmare. Is there any way to use the same server but just use
>> > different databases? For example, an SP1 database and an SP2 database on the
>> > same computer. Also mentioned is to restore an SP1 database and repository
>> > for supporting my SP1 images. This also sounds like a nightmare. Anyone else
>> > doing this?
>>
>>
>>


.

Relevant Pages

  • Re: problem with a DTS "Analysis Services Processing Task"
    ... "Darren Gosbell" wrote: ... Server A from Server B, then this is not the issue. ... database that you are trying to process. ... Where is your Olap Repository located? ...
    (microsoft.public.sqlserver.olap)
  • Re: Moving large cubes
    ... Are you sure that you can't archive the database? ... The limitation is that no *ONE* file can exceed 4GB. ... I dont have an option to "Edit the Repository connection string" ... how do I make the destination machine look at the new repository? ...
    (microsoft.public.sqlserver.olap)
  • Re: How to restore the connection on the Analysis server
    ... because this repository doesn't contain the latest metadata. ... running Analysis Server. ... when I migrated the Analysis Services database ... I migraded it on SQL Server during the install process. ...
    (microsoft.public.sqlserver.olap)
  • CMI Error 0x80070057 parameter incorrect after modifying database
    ... TargetDesigner fails to open an previously working slx file (or create a new ... I moved my database and repository from one PC to a newer one by copying the ... I opened the database in SQL Server ...
    (microsoft.public.windowsxp.embedded)
  • Re: problem with a DTS "Analysis Services Processing Task"
    ... Where is your Olap Repository located? ... If you repository is in a SQL database (especially if that database is ... not stored on Server "B"), check that the SQLOper user has access to ... Administrators" privilege. ...
    (microsoft.public.sqlserver.olap)