Re: Adding another server instance to another hard drive?
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 05/30/04
- Next message: johnnyyzzhang_at_sbcglobal.net: "Re: Profiler sees very different durations for the same SQL select stmt of spid(s) from different client workstations, a bug?"
- Previous message: Aaron [SQL Server MVP]: "Re: Computed 'Days to go' Column"
- In reply to: Niels: "Re: Adding another server instance to another hard drive?"
- Next in thread: Niels: "Re: Adding another server instance to another hard drive?"
- Reply: Niels: "Re: Adding another server instance to another hard drive?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 May 2004 11:24:28 -0500
A disaster recovery plan will help you minimize data loss. You need to
plan for various recovery scenarios according to the amount of data loss
that is acceptable to you.
The worst case is that you lose your computer completely due to a disaster
such as for or theft. Your only recourse in this situation is to reinstall
SQL Server on a working machine and restore from backups you've kept in a
safe location.
If your computer crashes and/or you lose your SQL Server drive, you might
get lucky with a successful attach of the database files if your database
files are intact. However, you should not rely on this and plan on
restoring your database from backup because you might not be able to attach
databases which were not detached properly.
The bottom line is that you need to backup your databases periodically and
archive the backup files to a safe location.
-- Hope this helps. Dan Guzman SQL Server MVP "Niels" <nkistrup@comcast.net> wrote in message news:NeudnYnNW-kXTiTdRVn2tQ@giganews.com... > Peter, > > So much for my mastery of English. I don't think I'm explaining the > situation correctly, sorry. > > I'm running Win 2000 Pro, with the developer's edition of MS SQL Server, but > I have 4 hard drives ... and it's all on my home computer (I'm the 'network > guy'). Maybe another server instance is not the correct terminology? > Currently my data is on D:, but I would like to use one of the other hard > drives to actively store data. > > If the computer crashes, I'm screwed, but I can always move the hard drive > to another machine. Heck the drive where the data is 6 1/2 yrs old, and has > migrated across machines in the past. (The hard drive.) > > Niels >
- Next message: johnnyyzzhang_at_sbcglobal.net: "Re: Profiler sees very different durations for the same SQL select stmt of spid(s) from different client workstations, a bug?"
- Previous message: Aaron [SQL Server MVP]: "Re: Computed 'Days to go' Column"
- In reply to: Niels: "Re: Adding another server instance to another hard drive?"
- Next in thread: Niels: "Re: Adding another server instance to another hard drive?"
- Reply: Niels: "Re: Adding another server instance to another hard drive?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
