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 |
|
LuckyItGuy
Starting Member
3 Posts |
 Posted - 2008-03-07 : 14:05:31
|
| If I have a sqlserver express database (very simple, 3 tables) where I have installed sqlserver express on my main internal "C" drive but changed the data files location to an external fast E-sata drive, my question is whether I can use an identical computer with an identical copy of sqlserver express installed, and the database tables etc set up the same, to access and use the same data as the first, assuming of course that I disconnect the e-sata drive from the first computer and plug it in to the second one??? Will this work?? Im trying to quickly get a small but critical data aquisition system back up with minimal loss of time and data if the first computer fails. O.S. is windows xp.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 23:23:42
|
| You can detach db from one server, move the disk to another server then attach the db. |
 |
|
|
LuckyItGuy
Starting Member
3 Posts |
Posted - 2008-04-04 : 07:23:02
|
| I am resurrecting this question because now that I am actually implementing it, I realize a problem; The whole purpose of this is to make sure the database survives if the first computer crashes and dies.The problem = if the first computer is dead, how do I detatch the database from it after Ive plugged the Esata drive with my database on it into the backup computer?? Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 23:45:43
|
| You should backup db in schedule and save db backup files in safe palce. |
|
|
|
|
|
|
SqlserverExpress with external e-sata drive???