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 |
|
sqltec
Starting Member
3 Posts |
 Posted - 2007-10-15 : 13:08:46
|
| I am in the process of creating a VM server which serves as a backup for a production SQL server. the SQL server has SQL directory installed on C:\ and F:\ partitions. Sql installation files reside on C:\ while MSSQL directory (include backup, logs, data, etc.. ) reside on F:\. The VM was created by cloning of the original (production) server but only C:\ partition. I need to use robocopy to copy the MSSQL directory from original sql (F:\) server to the VM (F:\). My questions are:1. will doing it this way mess up database integrity on the VM?2. What should I check to ensure installed filed registered to the new VM server instead of the original sql server? 3. what switches of robocopy should be used to produce exact copy of the MSSQL folder from original server to the VM4. the current database is about 1GB, how long the robocopy may take? If you have experienced this before, please share your thoughts, suggestions, ideas. Very much appreciate your feedback.Thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-15 : 22:23:58
|
| You have to stop sql to copy db files. Better to look at log shipping, replication or db mirroring. |
 |
|
|
|
|
|
Robocopy SQL server directory