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 |
|
rocksteer
Yak Posting Veteran
69 Posts |
 Posted - 2011-10-07 : 08:29:55
|
| Both platforms are Windows 2003 Server.Can we just move the hard disks containing the same operating systems and the databases from a non-RAID workstation to an actual server that has raid? Is there a way? Maybe with limited changes to the registry?If not will a backup from the non-RAID to the RAID work?How a SP_DETACH --> SP_ATTACH?How about copy_db? Disk would have to be slave as do not want to copy 300+ GB over the network. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-10-07 : 09:12:17
|
| The best and safest way to do it is to do a backup-restore sequence. Safe and simple. DO NOT just move the disks or copy the mdf's or whatever and expect things to work.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
rocksteer
Yak Posting Veteran
69 Posts |
Posted - 2011-10-07 : 09:48:38
|
| What about the logins that exist? I am mostly using mixed mode. |
|
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2011-10-07 : 11:21:42
|
| Lumbago is right....Since you're going from a single piece DB to a split DB (hard disk breakdown) keep it simple. The last thing you want to do is corrupt any data while trying to copy from one to the other in a live environment. Not that it wouldn't work...but I would at-least suggest trying it in a test environment before hand.As for the users..if they are domain based then that won't be a problem. If they are SQL based, then you might just have to recreate the SQL login as the mapping will already exist for the DB's. Same goes for local users.Steve |
|
|
|
rocksteer
Yak Posting Veteran
69 Posts |
Posted - 2011-10-10 : 12:44:35
|
| If we do end up using RAID, how do I assign data and transaction log drives?Currently between two (D and F). How does RAID look at it? Is RAID slower, because of the mirroring? |
|
|
|
|
|
|
Moving SQL Server 2000 non-RAID To RAID