hardware change

I am looking at having to do a hardware change in the
coming months.
The OS will be the same.
The version of SQL server will be the same.
My question is this:
Can I unattach all of the databases (including the system
databases) on the old server and then re-attach them on
the new server?
Would this gain me anything (like not having to re-create
jobs, etc)?
Just curious.
Thanks,
AdriaHi,
Have a look into the below link for moving all the databases to new server.
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Thanks
Hari
MCDBA
"Adria" <a-carbo@.tamu.edu> wrote in message
news:e31d01c43c2e$d345b6a0$a301280a@.phx.gbl...
> I am looking at having to do a hardware change in the
> coming months.
> The OS will be the same.
> The version of SQL server will be the same.
> My question is this:
> Can I unattach all of the databases (including the system
> databases) on the old server and then re-attach them on
> the new server?
> Would this gain me anything (like not having to re-create
> jobs, etc)?
> Just curious.
> Thanks,
> Adria|||Thank you very much. These two articles do a very good
job of explaining exactly how to do these things.
One question though ... is there an advantage to doing
things this way?
Best,
Adria
>--Original Message--
>Hi,
>Have a look into the below link for moving all the
databases to new server.
>Moving SQL Server Databases
>http://www.support.microsoft.com/?id=224071
>Moving Databases between Servers
>http://www.support.microsoft.com/?id=314546
>Thanks
>Hari
>MCDBA|||Adria,
Using detach/attach? It's just a lot easier and usually results in less
problems/issues.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
<anonymous@.discussions.microsoft.com> wrote in message
news:e2d801c43c32$6618cff0$a501280a@.phx.gbl...
> Thank you very much. These two articles do a very good
> job of explaining exactly how to do these things.
> One question though ... is there an advantage to doing
> things this way?
> Best,
> Adria
> >--Original Message--
> >Hi,
> >
> >Have a look into the below link for moving all the
> databases to new server.
> >
> >Moving SQL Server Databases
> >http://www.support.microsoft.com/?id=224071
> >
> >Moving Databases between Servers
> >http://www.support.microsoft.com/?id=314546
> >
> >Thanks
> >Hari
> >MCDBA
>|||Mark
I think the attach/detach may cause some problems rather BACKUP/RESTORE
commands.
Do you think so ,don't you?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:#3N830EPEHA.1512@.TK2MSFTNGP10.phx.gbl...
> Adria,
> Using detach/attach? It's just a lot easier and usually results in less
> problems/issues.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:e2d801c43c32$6618cff0$a501280a@.phx.gbl...
> > Thank you very much. These two articles do a very good
> > job of explaining exactly how to do these things.
> >
> > One question though ... is there an advantage to doing
> > things this way?
> >
> > Best,
> > Adria
> >
> > >--Original Message--
> > >Hi,
> > >
> > >Have a look into the below link for moving all the
> > databases to new server.
> > >
> > >Moving SQL Server Databases
> > >http://www.support.microsoft.com/?id=224071
> > >
> > >Moving Databases between Servers
> > >http://www.support.microsoft.com/?id=314546
> > >
> > >Thanks
> > >Hari
> > >MCDBA
> >
>