Move Sharepoint databases from MSDE to full SQLServer -- help!
- From: "Greg Latiak" <glatiak@xxxxxxxxxxxx>
- Date: Sat, 6 Aug 2005 22:02:43 -0400
Single user mode is the label used by the SQLServer product folk for getting
users (and applications) out of a database so it can be maintained or backed
up.
Instead of having system resources tied up by three instances of a database
server process - one for the active sqlserver databases, one for the
sbs$monitoring sharepoint site and one for the SBS company sharepoint site
(sqlserver 2000 and two slightly different versions of msde), what I want to
have is one database server process managing them all. This is not a heavily
used machine, so concurrent performance is not an issue.
All I think I want to do is just move the databases from MSDE to full size
sqlserver. DO not want to consolidate them, just switch which instance of
sqlserver processes them.
"Mike Walsh" <englantilainen@xxxxxxxxxxx> wrote in message
news:eF6RiDqmFHA.2080@xxxxxxxxxxxxxxxxxxxxxxx
> Maybe I'm thick but can you explain "single user mode" in a WSS context ?
>
> Also do you mean you intend to move two essentially different sets (two
> separate instances) of WSS databases to a single set of databases in SQL
> Server or are you retaining two sets of databases just have them stored in
> SQL Server ?
>
> Finally you say *the* server monitoring site. (My stress on "the"). There
> is
> no such thing that comes with standard WSS so probably you'll need to ask
> questions on moving that in the SBS newsgroup (microsoft.public.sbs) as is
> the case with any other non-standard WSS functionality
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ at http://wss.collutions.com
> Please reply to the newsgroup
>
> "Greg Latiak" <glatiak@xxxxxxxxxxxx> wrote in message
> news:e09Ir9pmFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
>>I am running SBS2003 Premium and have two sharepoint sites -- the base
>>company site created by the install and the server monitoring site. I
>>would
>>like to move their databases from two separate instances of MSDE to
>>SQLServer -- in order to enable common database maintenance procedures
>>(like backup).
>>
>> I have found the procedure for moving the databases into SQLserver, but
>> nothing on how to put the databases into single user mode to do the move.
>> And nothing on how to get Sharepoint to find the databases afterwards.
>>
>> Is there any documentation on how to proceed? Or any helpful suggestions?
>> Or is this a bad idea?
>>
>> thanks,
>>
>> Greg Latiak
>>
>>
>
>
.
- Follow-Ups:
- Re: Move Sharepoint databases from MSDE to full SQLServer -- help!
- From: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]
- Re: Move Sharepoint databases from MSDE to full SQLServer -- help!
- Prev by Date: Re: Post SP1 shutdown slow
- Next by Date: Re: Exchange 2003 sp1 setup problem
- Previous by thread: Post SP1 shutdown slow
- Next by thread: Re: Move Sharepoint databases from MSDE to full SQLServer -- help!
- Index(es):
Relevant Pages
|
