Thursday, February 16, 2012

Best way to move data to new server

I will shortly be moving some databases from an old server to a new one
(with a new name) and I am considering the best way to move the data.
DTS
Backup to disk and restore
Any ideas as to which is the best way?To add top Uri's post, if you need to move logins and passwords this page
will help
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OD8RtIOgDHA.3896@.tk2msftngp13.phx.gbl...
> mj
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 --
Move
> Databases between computers running by sql server
> Q304692 INF: Moving SQL Server DBs to a New Location w/ BACKUP & RESTORE
> <http://support.microsoft.com/support/kb/articles/q304/6/92.asp>
>
> "MJ" <supportnospa_m@.belmont.co.uk> wrote in message
> news:vmtbjesm4bko81@.corp.supernews.com...
> > I will shortly be moving some databases from an old server to a new one
> > (with a new name) and I am considering the best way to move the data.
> >
> > DTS
> > Backup to disk and restore
> >
> > Any ideas as to which is the best way?
> >
> >
>

No comments:

Post a Comment