Enterprise SQL move to Standard

Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
Server to a Standard SQL Server?
We would like to just stop the SQL services and move the DB's across, rename
the server to match the old server and start the new SQL server.
Will this work or will it break since we are going from Enterprise to
Standard?
--
Paul BergsonSee if this helps:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"Paul Bergson" wrote:
> Is it possible to follow the steps of moving ALL db's from an Enterprise SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across, rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>
>|||I have seen this. I want to know if I can move between Enterprise and
standard.
The bad thing about these newgroups is once someone answers in a thread a
lot of people no longer see them. So I will probably have to repost.
--
Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> See if this helps:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>
> AMB
>
> "Paul Bergson" wrote:
> > Is it possible to follow the steps of moving ALL db's from an Enterprise
SQL
> > Server to a Standard SQL Server?
> >
> > We would like to just stop the SQL services and move the DB's across,
rename
> > the server to match the old server and start the new SQL server.
> >
> > Will this work or will it break since we are going from Enterprise to
> > Standard?
> >
> > --
> >
> > Paul Bergson
> >
> >
> >|||I think there is not a problem moving dbs between editions. At least there is
not a single comment in both KB articles, the one I posted and this one.
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/kb/224071/EN-US/
I have done it before (moving user dbs) between servers with diff edition,
and have not got any problem till now.
AMB
"Paul Bergson" wrote:
> I have seen this. I want to know if I can move between Enterprise and
> standard.
> The bad thing about these newgroups is once someone answers in a thread a
> lot of people no longer see them. So I will probably have to repost.
> --
> Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> > See if this helps:
> >
> > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> >
> >
> > AMB
> >
> >
> > "Paul Bergson" wrote:
> >
> > > Is it possible to follow the steps of moving ALL db's from an Enterprise
> SQL
> > > Server to a Standard SQL Server?
> > >
> > > We would like to just stop the SQL services and move the DB's across,
> rename
> > > the server to match the old server and start the new SQL server.
> > >
> > > Will this work or will it break since we are going from Enterprise to
> > > Standard?
> > >
> > > --
> > >
> > > Paul Bergson
> > >
> > >
> > >
>
>|||Shouldn't be a problem, since the real difference in the editions is things
like clustering support, log shipping, cpu and memory specs, etc. Its not
like DBCC Indexdefrag is going to be different in one edition vs. the
other...
Of course...you should be testing this in your lab anyway to confirm :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
> Is it possible to follow the steps of moving ALL db's from an Enterprise
> SQL
> Server to a Standard SQL Server?
> We would like to just stop the SQL services and move the DB's across,
> rename
> the server to match the old server and start the new SQL server.
> Will this work or will it break since we are going from Enterprise to
> Standard?
> --
> Paul Bergson
>|||Ok
Thanks
--
Paul Bergson
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:#4y4ru8VFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Shouldn't be a problem, since the real difference in the editions is
things
> like clustering support, log shipping, cpu and memory specs, etc. Its not
> like DBCC Indexdefrag is going to be different in one edition vs. the
> other...
> Of course...you should be testing this in your lab anyway to confirm :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ua7SFT8VFHA.3176@.TK2MSFTNGP12.phx.gbl...
> > Is it possible to follow the steps of moving ALL db's from an Enterprise
> > SQL
> > Server to a Standard SQL Server?
> >
> > We would like to just stop the SQL services and move the DB's across,
> > rename
> > the server to match the old server and start the new SQL server.
> >
> > Will this work or will it break since we are going from Enterprise to
> > Standard?
> >
> > --
> >
> > Paul Bergson
> >
> >
>|||Ok
Thanks
--
Paul Bergson
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:09828E93-517B-47FE-8D3E-FE4017A12C1C@.microsoft.com...
> I think there is not a problem moving dbs between editions. At least there
is
> not a single comment in both KB articles, the one I posted and this one.
> Moving SQL Server databases to a new location with Detach/Attach
> http://support.microsoft.com/kb/224071/EN-US/
> I have done it before (moving user dbs) between servers with diff edition,
> and have not got any problem till now.
>
> AMB
> "Paul Bergson" wrote:
> > I have seen this. I want to know if I can move between Enterprise and
> > standard.
> >
> > The bad thing about these newgroups is once someone answers in a thread
a
> > lot of people no longer see them. So I will probably have to repost.
> >
> > --
> >
> > Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
message
> > news:F21A54AA-F591-4F4D-894B-806F1C9061C9@.microsoft.com...
> > > See if this helps:
> > >
> > > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> > >
> > >
> > > AMB
> > >
> > >
> > > "Paul Bergson" wrote:
> > >
> > > > Is it possible to follow the steps of moving ALL db's from an
Enterprise
> > SQL
> > > > Server to a Standard SQL Server?
> > > >
> > > > We would like to just stop the SQL services and move the DB's
across,
> > rename
> > > > the server to match the old server and start the new SQL server.
> > > >
> > > > Will this work or will it break since we are going from Enterprise
to
> > > > Standard?
> > > >
> > > > --
> > > >
> > > > Paul Bergson
> > > >
> > > >
> > > >
> >
> >
> >