[THIN] Re: Moving SQL Datastore - Jeff Durbin?
- From: "Jeff Durbin" <techlists@xxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 17:02:08 +1300
Hi Michael,
The data was from the field notes I created the day I figured it out,
which is why the formatting was bad; I had copied it from a Word document.
I've just dug out the original document and pasted the contents into a new
document which I will email you off-list.
Jim's way sounds a lot simpler than mine. I didn't know SQL particularly
well, so I had to fight my way through it. The method I came up with does
work though, if you need it as a fallback.
Regards,
JD
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx
> [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Michael
> Sent: Thursday, 11 March 2004 4:10 p.m.
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Moving SQL Datastore - Jeff Durbin?
>
> This is pretty much along the lines of what I was expecting.
> The document I found, however, noted that you would need to
> create a new db owner and fiddle with the stored procedures.
> Is this not necessary?
>
> I'll give this a this weekend so I can finally get rid of
> some of this old hardware. :D
>
> Thanks again!
>
> Michael Saul
> --- "Jim Kenzig http://thethin.net";
> <jimkenz@xxxxxxxxxxxxxx> wrote:
> > See http://thethin.net/archive3.cfm?id=90893
> >
> > I've moved the Thin archives database to different servers several
> > times.
> > How I do it is back it up to disk using th SQL backup and
> then create
> > an empty database on the new server and restore the backup
> file. It is
> > pretty simple.
> >
> > JK
> >
> > -----Original Message-----
> > From: thin-bounce@xxxxxxxxxxxxx
> > [mailto:thin-bounce@xxxxxxxxxxxxx]On
> > Behalf Of Michael
> > Sent: Wednesday, March 10, 2004 8:25 PM
> > To: thin@xxxxxxxxxxxxx
> > Subject: [THIN] Re: Moving SQL Datastore - Jeff Durbin?
> >
> >
> > After even more searching (through google, and not the thin list
> > archive) I found Jeff Durbin's guide to performing a database move.
> >
> > Jeff, do you still have the word format of that document?
> THe archive
> > mangled it pretty badly, and I can't tell when you use
> quotes or other
> > special characters.
> >
> > Thanks again!
> >
> > Michael Saul
> > --- Michael <indy019@xxxxxxxxx> wrote:
> > > I have been asked to move the Data Store to a new SQL server. Is
> > > there a recommended way to do this?
> > Is
> > > there anything I should look out for?
> > >
> > > This is the plan I was thinking of taking:
> > >
> > > Stop all IMA services
> > > Detach database from old server
> > > Move database to new server and reattach Run dsmaint /config to
> > > point to the new SQL server Start IMA serrvice
> > >
> > > Will this work? Is there anything I'm missing?
> > >
> > > Thanks in advance.
> > >
> > > Micahael Saul
> > >
> >
> >
> ********************************************************
> > This weeks sponsor Emergent Online.
> > Emergent OnLine is the leading server-based computing consulting
> > integration firm in the nation.
> > Emergent OnLine delivers expert
> > consulting services you can depend on.
> > http://www.go-eol.com
> >
> **********************************************************
> > Useful Thin Client Computing Links are available at:
> > http://thin.net/links.cfm
> >
> ***********************************************************
> > For Archives, to Unsubscribe, Subscribe or set Digest or
> Vacation mode
> > use the below link:
> > http://thin.net/citrixlist.cfm
>
> ********************************************************
> This weeks sponsor Emergent Online.
> Emergent OnLine is the leading server-based computing
> consulting integration firm in the nation. Emergent OnLine
> delivers expert consulting services you can depend on.
> http://www.go-eol.com
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or set Digest or
> Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>
********************************************************
This weeks sponsor Emergent Online.
Emergent OnLine is the leading server-based computing consulting integration
firm in the nation. Emergent OnLine delivers expert
consulting services you can depend on.
http://www.go-eol.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
