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 |
|
pjg61
Starting Member
2 Posts |
 Posted - 2014-03-07 : 18:21:20
|
| I built a small system using SQL Server 2012 for a ski shop. Not many transactions per day. I use "SQL Backup and FTP" every nigt to backup the database onto a cloud folder. The system running SQL Server has mirrored disks. Recently, we have a computer failure which brought out two problems:1) If I remove the disk from the dead machine, how can I copy/replace/insert (don't know) the data from the drive into a new system identically setup ? Can I plug the disk (say USB) into a new system and somehow copy the database to the new machine ?IF NOT, THEN2) Given that I back up every night, is there a way that I can log transactions to an alternate location (say a USB key) so that if my system dies, I simply boot up my backup server, restore the last night's data and then apply the transactions since that backup ?Thank you |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-03-08 : 03:02:13
|
| For option 2) - yes, you can take a nightly full backup and regular log backups . In the scenario , of restore you restore the full backup and apply the transaction log files. You have two issues:1) Identify the Recovery Point objective(RPO) - your backups should reflect this recovery point2)Recovery time objective(RTO) - from the point of failure how quickly do you want to recover. The methods of backup , such as storage should support this RTOJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
pjg61
Starting Member
2 Posts |
Posted - 2014-03-08 : 12:58:06
|
| Jack,OK. For (2), can you tell me or point me to info on how I can configure the transaction log files to an alternate drive ? Then, how do I re-apply the transactions to put my database to the same state ?Thanks,Pierre |
|
|
|
|
|
|
|
|
How to deal with a machine failure