all I have a beefy server that currenty runs my SQL server, however i would like to backup this server and restore it to a different server then use SQL replication in a DR solution.
I have W3K R2 SP1 with SQL 2005 (version 9.00.3042.00)
The phycial server has:
DISK 0 - C: (conatins OS and system files 12GB)
and E: (conatins SQL logs 124GB)
DISK 1 - D: (some program files, and the SQL DB 408GB) - Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
all DISK's are NTFS formatted
How can I best accomplish my goal?
Should I use NTBACKUP and then do a restore onto a new server?
Should I build a new sever with W3KR2 with the same partitions and then backup the sql db via sql and do a restore onto the new server?
could I utilise hyper-v?
I do not have much experience with MS SQL server.
View Complete Post