WSS3 SQL2005 - move databases

Hello,

I am using WSS3 with my config and content databases in SQL2005 on the same
machine. I would like to move both databses to a SQL instance on a different
machine.

Is there any simple way to do this?

Thanks!

Rick
Wed Jul 09 22:01:04 CDT 2008

First backup your site.
At a command prompt
C:
cd\
cd Program Files\Common Files\Microsoft Shared\web server
extensions\12\BIN>stsadm -o export -url
"https://yoursharepointsite.com/" -filename
E:\SPBackup\home -includeusersecurity -quiet -nofilecompression

Then you can go into you "Central Administration" / "Application Management"
/ "Content Databases"

You can remove and then add the new one.


Information is provided as is not guarantee this ideas will work


"Avis" <Avis@discussions.microsoft.com> wrote in message
news:19CDB586-4DF3-44AF-8228-DF2D2091F29C@microsoft.com...
> Hello,
>
> I am using WSS3 with my config and content databases in SQL2005 on the
> same
> machine. I would like to move both databses to a SQL instance on a
> different
> machine.
>
> Is there any simple way to do this?
>
> Thanks!

Avis
Wed Jul 09 22:41:00 CDT 2008

Thank you.

Is there a way to also move the configuration database?

Thanks again,

Avery

"Rick V" wrote:

> First backup your site.
> At a command prompt
> C:
> cd\
> cd Program Files\Common Files\Microsoft Shared\web server
> extensions\12\BIN>stsadm -o export -url
> "https://yoursharepointsite.com/" -filename
> E:\SPBackup\home -includeusersecurity -quiet -nofilecompression
>
> Then you can go into you "Central Administration" / "Application Management"
> / "Content Databases"
>
> You can remove and then add the new one.
>
>
> Information is provided as is not guarantee this ideas will work
>
>
> "Avis" <Avis@discussions.microsoft.com> wrote in message
> news:19CDB586-4DF3-44AF-8228-DF2D2091F29C@microsoft.com...
> > Hello,
> >
> > I am using WSS3 with my config and content databases in SQL2005 on the
> > same
> > machine. I would like to move both databses to a SQL instance on a
> > different
> > machine.
> >
> > Is there any simple way to do this?
> >
> > Thanks!
>

Avis
Thu Jul 10 10:56:01 CDT 2008

How do I tell WSS to look at the new location though is the question?

"Rick V" wrote:

> As far as the SQL goes there a a few ways you can do it. You can disconnect
> move the files and reconnect in the SQL Management Studio. The way I would
> do it is make a backup and then leave the original in place restore it on
> another server and then do you stuff with Central Administration this way
> you have both Databases incase you have to go back.
>
> "Avis" <Avis@discussions.microsoft.com> wrote in message
> news:800A043A-0E4E-4F85-9795-222C6D118BEE@microsoft.com...
> > Thank you.
> >
> > Is there a way to also move the configuration database?
> >
> > Thanks again,
> >
> > Avery
> >
> > "Rick V" wrote:
> >
> >> First backup your site.
> >> At a command prompt
> >> C:
> >> cd\
> >> cd Program Files\Common Files\Microsoft Shared\web server
> >> extensions\12\BIN>stsadm -o export -url
> >> "https://yoursharepointsite.com/" -filename
> >> E:\SPBackup\home -includeusersecurity -quiet -nofilecompression
> >>
> >> Then you can go into you "Central Administration" / "Application
> >> Management"
> >> / "Content Databases"
> >>
> >> You can remove and then add the new one.
> >>
> >>
> >> Information is provided as is not guarantee this ideas will work
> >>
> >>
> >> "Avis" <Avis@discussions.microsoft.com> wrote in message
> >> news:19CDB586-4DF3-44AF-8228-DF2D2091F29C@microsoft.com...
> >> > Hello,
> >> >
> >> > I am using WSS3 with my config and content databases in SQL2005 on the
> >> > same
> >> > machine. I would like to move both databses to a SQL instance on a
> >> > different
> >> > machine.
> >> >
> >> > Is there any simple way to do this?
> >> >
> >> > Thanks!
> >>
>

Rick
Thu Jul 10 13:26:13 CDT 2008

Central Administration" / "Application Management" / "Content Databases" You
can add a new one here.

Backup before you do anything. If your circumstances allow test your backup.

"Avis" <Avis@discussions.microsoft.com> wrote in message
news:A35BBB03-952B-421E-88BC-BCF6912047D2@microsoft.com...
> How do I tell WSS to look at the new location though is the question?
>
> "Rick V" wrote:
>
>> As far as the SQL goes there a a few ways you can do it. You can
>> disconnect
>> move the files and reconnect in the SQL Management Studio. The way I
>> would
>> do it is make a backup and then leave the original in place restore it on
>> another server and then do you stuff with Central Administration this way
>> you have both Databases incase you have to go back.
>>
>> "Avis" <Avis@discussions.microsoft.com> wrote in message
>> news:800A043A-0E4E-4F85-9795-222C6D118BEE@microsoft.com...
>> > Thank you.
>> >
>> > Is there a way to also move the configuration database?
>> >
>> > Thanks again,
>> >
>> > Avery
>> >
>> > "Rick V" wrote:
>> >
>> >> First backup your site.
>> >> At a command prompt
>> >> C:
>> >> cd\
>> >> cd Program Files\Common Files\Microsoft Shared\web server
>> >> extensions\12\BIN>stsadm -o export -url
>> >> "https://yoursharepointsite.com/" -filename
>> >> E:\SPBackup\home -includeusersecurity -quiet -nofilecompression
>> >>
>> >> Then you can go into you "Central Administration" / "Application
>> >> Management"
>> >> / "Content Databases"
>> >>
>> >> You can remove and then add the new one.
>> >>
>> >>
>> >> Information is provided as is not guarantee this ideas will work
>> >>
>> >>
>> >> "Avis" <Avis@discussions.microsoft.com> wrote in message
>> >> news:19CDB586-4DF3-44AF-8228-DF2D2091F29C@microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I am using WSS3 with my config and content databases in SQL2005 on
>> >> > the
>> >> > same
>> >> > machine. I would like to move both databses to a SQL instance on a
>> >> > different
>> >> > machine.
>> >> >
>> >> > Is there any simple way to do this?
>> >> >
>> >> > Thanks!
>> >>
>>

Trix
Mon Sep 08 01:00:01 CDT 2008

"Rick V" wrote:

> Central Administration" / "Application Management" / "Content Databases" You
> can add a new one here.
>
> Backup before you do anything. If your circumstances allow test your backup.
>
> "Avis" <Avis@discussions.microsoft.com> wrote in message
> news:A35BBB03-952B-421E-88BC-BCF6912047D2@microsoft.com...
> > How do I tell WSS to look at the new location though is the question?
> >


As Avis asked, we want to know how to repoint the ADMINISTRATION database as
well as the content ones.

Yes, copying the dbs is pretty straightforward, and now we can change the
location of the content dbs, but if our admin db is also hosted on the
server, it's not immediately obvious where we change this setting inside WSS
once we've moved the db.

The
Mon Sep 08 05:38:43 CDT 2008

On Sep 8, 2:00=A0am, Trix <T...@discussions.microsoft.com> wrote:
> "Rick V" wrote:
> > Central Administration" / "Application Management" / "Content Databases=
" You
> > can add a new one here.
>
> > Backup before you do anything. If your circumstances allow test your ba=
ckup.
>
> > "Avis" <A...@discussions.microsoft.com> wrote in message
> >news:A35BBB03-952B-421E-88BC-BCF6912047D2@microsoft.com...
> > > How do I tell WSS to look at the new location though is the question?
>
> As Avis asked, we want to know how to repoint the ADMINISTRATION database=
as
> well as the content ones.
>
> Yes, copying the dbs is pretty straightforward, and now we can change the
> location of the content dbs, but if our admin db is also hosted on the
> server, it's not immediately obvious where we change this setting inside =
WSS
> once we've moved the db.
Hi Avis,

Definately backup your databases and make sure you have the latest
patches installed on your Source and Destination farm. Also, if you
are going to be running the same databases on the same SQL server
instance, make sure you use the -preparetomove command before
detatching the databases "or you will get syncronization issues". I
usually make a dummy instance on a new web application, detatch the
database, attach my backup, and then stsadm -o addcontentdb -
servername "server"

This goes over moving the config DB to a seperate server using STSADM
http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-con=
figuration-databases/

Full scripted installation of MOSS "If anything goes wrong"
http://www.mindsharpblogs.com/ben/archive/2008/03/08/4411.aspx

Hope this helps.... Always backup! :-)

The
Mon Sep 08 05:47:27 CDT 2008

On Sep 8, 6:38=A0am, The General <digital2...@gmail.com> wrote:
> On Sep 8, 2:00=A0am, Trix <T...@discussions.microsoft.com> wrote:
>
>
>
> > "Rick V" wrote:
> > > Central Administration" / "Application Management" / "Content Databas=
es" You
> > > can add a new one here.
>
> > > Backup before you do anything. If your circumstances allow test your =
backup.
>
> > > "Avis" <A...@discussions.microsoft.com> wrote in message
> > >news:A35BBB03-952B-421E-88BC-BCF6912047D2@microsoft.com...
> > > > How do I tell WSS to look at the new location though is the questio=
n?
>
> > As Avis asked, we want to know how to repoint the ADMINISTRATION databa=
se as
> > well as the content ones.
>
> > Yes, copying the dbs is pretty straightforward, and now we can change t=
he
> > location of the content dbs, but if our admin db is also hosted on the
> > server, it's not immediately obvious where we change this setting insid=
e WSS
> > once we've moved the db.
>
> Hi Avis,
>
> Definately backup your databases and make sure you have the latest
> patches installed on your Source and Destination farm. =A0Also, if you
> are going to be running the same databases on the same SQL server
> instance, make sure you use the -preparetomove command before
> detatching the databases "or you will get syncronization issues". =A0I
> usually make a dummy instance on a new web application, detatch the
> database, attach my backup, and then stsadm -o addcontentdb -
> servername "server"
>
> This goes over moving the config DB to a seperate server using STSADMhttp=
://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-a...
>
> Full scripted installation of MOSS "If anything goes wrong"http://www.min=
dsharpblogs.com/ben/archive/2008/03/08/4411.aspx
>
> Hope this helps.... Always backup! :-)- Hide quoted text -
>
> - Show quoted text -

Also make sure the service account has full access "db owner" to the
SQL Databases, and SQL Services.