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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2006-01-05 : 23:52:27
|
| HiI am using server 2000 , I question is - if server crashed then can we recover data.. how?thanksasm |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-06 : 00:03:06
|
| Yes if you have backupMadhivananFailing to plan is Planning to fail |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-06 : 02:16:20
|
| HiSQL has a Backup facilty that allows you to backup your databases periodically.It is recommended that you place the backups on a different drive from your MDFs & LDFs and if possible have an extra copy of the backup Offsite (in case of fires or malicious damage).In the event of a database crash, you can restore your database to the state it was in when you made your backup.Read the following:[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_94oj.asp[/url]RegardsNIf you want your computer to be faster then throw it out of the window. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-06 : 05:12:43
|
| "if server crashed"In the case of, say, a powercut the database will most likely need no action. Transactions that were "in progress" will be reversed, so the database will be in a consistent state.However, if you disks have caching controllers you are hosed!There is a SQL command to check the "consistency" of your database - so that would tell you if it was safe to carry on, or whether you need to recover.Either way you need backups on different media/computers to recover from a catastrophic failure of your server, as the others have said.SQL Server has three types of backups - FULL (one file contains everything for a restore), DIFFERENTIAL - a potentially smaller backup file with everything since the last FULL (two files to restore) and TRANSACTION - every change to the database is stored in a sequential file, you would back this up every few minutes, and then the restore becomes FULL then DIFF (if you have one) and then EACH Trans. backup in turn.You can also restore the Trans. backups up to a moment in time - e.g. just before you did that DELETE ALL ROWS IN MY_VERY_IMPORTANT_TABLE !!Trans. backups are optional, and the database can be set to NOT store the transaction data - which saves disk space when a Restore from FULL backup is all that your business needsKristen |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-06 : 05:50:32
|
| That sums it up nicely!NIf you want your computer to be faster then throw it out of the window. |
|
|
|
|
|
|
|
|
server crashed