Re: Don't want numbers in SPS DB's



Why do you care there is a number in the name?

I don't recommend this or really know for sure it will work but if you are
really this desperate you can try. Create your portal. It will name it
spsdev1_. Then delete your portal but do not delete the databases. Now
rename the databases to whatever you want. (You may have to detach them
from SQL first.) Then go back into SPS do create a portal, then choose
restore. Then you can manually type in the name of the databases you want
to attach to. I have no clue if this will work and I recommend you do not
try this in anything but a test environment. I have NEVER done this before.


--
Shane Young
SharePoint911 - "SharePoint Help...Now!"


"Dan Marth" <danmarth@xxxxxxxxxxx> wrote in message
news:O%23LbsUYrFHA.2212@xxxxxxxxxxxxxxxxxxxxxxx
>I have tried everything during and after an install to get rid of the damn
>number "1" that get put behind the name of your site on the PROF, SERV and
>SITE DB's. I hate my databases called spsdev1_PROF, spsdev1_SERV and
>spsdev1_SITE. Can I re-name these to get rid of the number "1" or is there
>someway during the install you can change the name? Any help would be
>greatly appreciated.
>
> Thanks in advance,
> Dan
>


.



Relevant Pages

  • Re: To Split or not to Split
    ... FWIW, a primary reason for me to split databases, is nothing to do with ... recommend such, I just used a guinea pig customer to try it)(not theory, ... I have indicated above, that even if unsplit databases work, they are clearly ...
    (microsoft.public.access.security)
  • Re: Reference material recommendations
    ... I've found over the years that this newsgroup is an absolute fountain of knowledge and I have been able to use heaps of stuff in the databases I've written. ... I need to extend my reference material further and was wondering what resources people recommend. ... The most recent publication recommended is Microsoft Access Version 2002 Step by Step. ...
    (comp.databases.ms-access)
  • Advantages and disadvantages of multiple instances on a cluster
    ... Looking for advice rather than the solution to a specific question here. ... my company's existing 2-node active/passive SQL Server 2005 cluster. ... databases. ... So I figured that I would recommend the creation of a number of additional ...
    (microsoft.public.sqlserver.clustering)
  • Re: object databases
    ... So after years of using strictly relational databases, ... Object databases seem compelling, especially ... When would you recommend ODBMS, ...
    (comp.object)
  • Re: How do I upgrade an older version of MSDE?
    ... > How do I upgrade an older version of MSDE? ... In my opinion the steps I would recommend: ... - install the latest version ... - restore your databases. ...
    (microsoft.public.sqlserver.msde)

Quantcast