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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-03 : 11:31:00
|
| Igor writes "Just a quick question for Andy regarding the article mentioned above. Does it also work if the new SQL Server version have a different location. Examle: Before it was located at C:/Program Files/MS SQL 2000 and new one will be at d:/SQL? If it does not work then what would be the best strategy for accomplishing it?Thank you.P.S. I've done quite a bit of research and found many articles about moving almost anything into SQL Server except SQL Server to Sql Server. Isn't it funny?" |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2003-01-03 : 11:56:06
|
| I just moved SQL 2000 dbs the other day, I used a complete backup to do the transfer ... then with a manual T-SQL command for RESTORE DATABASE WITH MOVE i was able to move the data and log files successfully... i just then ran a script to re-sync the users... no big deal, was a lot simplier than i anticipated...RESTORE FILELISTONLY FROM DISK='c:\mybackup'this gives you all the files inside the backup that you need to move then you doRESTORE DATABASE myDatabase FROM DISK='c:\mybackup' WITH MOVE 'myDatabase_data' TO 'd:\sql\myDatabase.mdf', MOVE 'myDatabase_log' TO 'd:\sql\myDatabase.ldf', REPLACEit worked nicely... |
 |
|
|
|
|
|
Moving SQL to a New Server