Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scabral7
Yak Posting Veteran
57 Posts |
 Posted - 2012-05-02 : 10:09:01
|
| Hi,We currently have a SQL 2008 datawarehouse server with about 15 different databases.We were given a new Server (faster,more memory,etc..) with a fresh copy of SQL 2008 R2 installed.I will need to move all of the databases from the old SQL server to the new SQL server. The issue that i have is that on the current SQL server, we have a C: and D: drive. Some of the databases and logs are on C: and others on D:. On the new SQL server we have C:, D:, and E: drives.What is the best way to move the databases from the old SQL server to the new SQL server and have the files reside on a different drive? For example, If i have database called ABC and the data and log files are stored on C:\DataFiles. I want to move them to the new SQL server and have the data file on D:\DataFiles and the log file on E:\LogFiles.I will also be moving the system databases as well. Those all reside on C: and will be on C: on the new server. I imagine i will have to move those first.Since this is a datawarehouse, i don't have any issues with stopping the service if I need to.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-05-02 : 12:40:28
|
| Best way is to restore your latest backups.Use the WITH MOVE option in the RESTORE statement. |
 |
|
|
|
|
|
Migrating SQL to a new Server