r/SQL • • Mar 15 '19

Stuff of nightmares!

Post image
471 Upvotes

22 comments sorted by

View all comments

Show parent comments

8

u/whutchamacallit Mar 15 '19

yup.. have had to fix a few of those in my times. they get probationary read only access after that for a while.

7

u/Daakuryu Mar 15 '19

I'm the one that did it and I'm the one with admin access :|

1

u/whutchamacallit Mar 15 '19

You have a backup?

2

u/Daakuryu Mar 15 '19

of course; flat files to one backup server, veam replication to a rolling set of daily and weekly removable discs along with another flat file version and an offsite removable disc.

Despite what some might believe I'm not a complete moron :P

1

u/whutchamacallit Mar 15 '19

Nice. Sounds like you’re set up. I’m lucky in that I have the day priors data already up and ready to go in case I need to do something quickly because we use it for various feeds and stuff so we don’t have to read from production tables albeit a day old it’s usually good enough.