Re: Supporting SP1 and SP2 Databases

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

  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • RE: Error 3085 Format$ being changed to [Format$] in query by one
    ... We are single-user database. ... The Boss wanted it there so the Network daily backup would ... the database on the Network server drive) will be a safe starting point. ... When you say it "works great from two different machines" do you mean that ...
    (microsoft.public.access.queries)
  • Re: Need to block port 1521 for all machines except one.
    ... Database server, but not through the Application server. ... Need to block port 1521 for all machines except one. ...
    (RedHat)
  • Re: Performance of ODBC
    ... VPC or Virtual Server and accessing this session via VNC (see ... There are also ISP sites that will offer you access to Terminal Services to ... database happens on your LAN. ... other machines off site would get the data at my present slow rate. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: DHCP Not working properly
    ... Here are two Event Viewer entries from the server: ... The following problem occurred with the Jet database -1032: ... The DHCP service encountered the following error when backing up the ... These two machines will not pick up a DHCP address from the server. ...
    (microsoft.public.windows.server.sbs)
Loading