Thanks for the ChMS blogs--I've been getting some good info. Are we talking MS SQL here? If so, if you set up your backups correctly, you can actually do point-in-time restores. If you forget the WHERE clause at 4:55pm on Monday after a full day of manual entry, you can restore to 4:54pm. It's a little tricky (requires full+log backups) but it's pretty cool when you need it. And/or do a full backup before any manual SQL work. SQL lets you back up without stopping the database.
1 comment:
Thanks for the ChMS blogs--I've been getting some good info. Are we talking MS SQL here? If so, if you set up your backups correctly, you can actually do point-in-time restores. If you forget the WHERE clause at 4:55pm on Monday after a full day of manual entry, you can restore to 4:54pm. It's a little tricky (requires full+log backups) but it's pretty cool when you need it. And/or do a full backup before any manual SQL work. SQL lets you back up without stopping the database.
Post a Comment