moving all databases to new server including sql server configurat

Hi,
We are getting a new server and need to move all the sql server database to this new server including configuration of the current sql server software. What is the best way to do this? Currently, we do not have any backup of the production.
Thanks,
Jack
Probably the easiest way is to detach the databases and copy to new server and attach. Depending on your security model, you could also use the DTS import login functions to bring users over
"Jack" wrote:

> Hi,
> We are getting a new server and need to move all the sql server database to this new server including configuration of the current sql server software. What is the best way to do this? Currently, we do not have any backup of the production.
> Thanks,
> Jack
|||Have a look at this: http://vyaskn.tripod.com/moving_sql_server.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:B4462402-6091-4D5B-B0DB-1C61BE5F3E45@.microsoft.com...
Hi,
We are getting a new server and need to move all the sql server database to
this new server including configuration of the current sql server software.
What is the best way to do this? Currently, we do not have any backup of the
production.
Thanks,
Jack
|||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
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:B4462402-6091-4D5B-B0DB-1C61BE5F3E45@.microsoft.com...
> Hi,
> We are getting a new server and need to move all the sql server database
to this new server including configuration of the current sql server
software. What is the best way to do this? Currently, we do not have any
backup of the production.
> Thanks,
> Jack