General information
Forum:
Microsoft SQL Server
Category:
Database management
>We installed SQL server on a machine on our network with the intention of only prototyping a system. Unfortunately we bacame invested in the data which resides on this server. We would like to set up another machine as the Server and move all the databases to this new machine. After doing this we will uninstall SQL Server fromthe first machine. Could someone detail the steps required to accomplish these ( probably quite simple) tasks?
>
>Thanks
>
>Glenn
As Evan suggests, sp_attach & sp_detach should work. I would also suggest using the DTS Import/Export wizard to copy complete databases by selecting (on the third or fourth step after specifying the source and destination) the "Transfer all database objects" option. Of course you will need to install SQL Server first on the new machine for this to work.
As with sp_detach and sp_attach, this process needs to be repeated for each database that you want to transfer.
I haven't had a need to copy all db's from a server so I don't know if there is an easier way. HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only