Viewing 15 posts - 376 through 390 (of 465 total)
Jamie Scharbrough (10/17/2012)
Well, it also depends on how small we're talking and how comfortable you are with backups in general.
Biggest DB is a bit over 100MB, and my experience with...
October 17, 2012 at 12:35 pm
Abu Dina (10/17/2012)
pdanes (10/17/2012)
You think, then, that such a cascaded full/differential/transaction approach makes sense, even given the situation I've described? If so, may I ask for your reasoning on the...
October 17, 2012 at 11:59 am
Well, this isn't exactly SQL stuff, and I'm no expert, but...
If I was in charge of the machine, I hope I'd have enough sense to keep it from ever getting...
October 17, 2012 at 11:38 am
Jamie Scharbrough (10/17/2012)
I'd say a weekly full (I like...
October 17, 2012 at 11:05 am
Square brackets, as Gail told you, are always a safe way to refer to fields, even if you don't have spaces. Some languages also have accent marks, which can raise...
October 17, 2012 at 10:51 am
I'd get my shotgun and go find the clown who's in charge of the mail server. -Somebody- must be responsible for the machine - he should never have let it...
October 17, 2012 at 10:46 am
Yes, I've read that sort of advice as well, and it's certainly true, but it's difficult to restore something without first having backed it up. I was looking for some...
October 17, 2012 at 10:40 am
Almost exclusively RDP, since I have to perform other tasks on the servers as well. I'm the only developer / DBA / operator in the entire shop. The machine is...
October 17, 2012 at 9:15 am
GilaMonster (9/21/2012)
Not talking about the backup process itself.You know that the backup completed successfully. Not the same as knowing that the backup file is good.
I guess I see. Of course,...
September 21, 2012 at 3:18 pm
Lynn Pettis (9/21/2012)
A hardware or IO failure. Disk sectors can go bad on you.
Well, yes, but that can happen even after you've created and test-restored a backup. I plan...
September 21, 2012 at 2:06 pm
Okay, that makes sense. But then I don't understand what can be wrong with the backup. If I run checkDB, I know my database is good. If I back up...
September 21, 2012 at 1:36 pm
Well, then why does Grant (and others) make a point of saying you should test-restore the backup? If the checksum is enough to guarantee that the backup was done correctly,...
September 21, 2012 at 1:23 pm
I realize I'm getting pretty far out there with all this, but...
If the backup with checksum can look okay, but still be corrupt, couldn't restoring that failed backup also look...
September 21, 2012 at 1:00 pm
gwardell (9/9/2012)
September 9, 2012 at 1:30 pm
gwardell (9/8/2012)
I was on a project once where I told NOT to document something because he/they would never read it.Later I was criticized because nobody understood my code.
Duh?
The two are...
September 9, 2012 at 3:36 am
Viewing 15 posts - 376 through 390 (of 465 total)