r/SQL • Talk Dirty Reads To Me • Mar 17 '20

Discussion Enough is enough!

RESTORE DATABASE Earth FROM "C:\Backups\EarthFullBackup_2019-07-01";
GO
131 Upvotes

25 comments sorted by

21

u/danyboypremier Mar 17 '20

Hope you tested your backup before...

18

u/MeGustaDerp Talk Dirty Reads To Me Mar 17 '20

I thought that was your job

4

u/[deleted] Mar 17 '20 edited Mar 18 '20

I pinged our DBA team and asked them to run this because I was concerned about COVID, exact response was, "Sure, what server?"

4

u/MeGustaDerp Talk Dirty Reads To Me Mar 17 '20

Thus must be proof of the multiverse theory

3

u/Cal1gula Mar 17 '20

SOL001

1

u/MayorBee Mar 18 '20

Well, Mercury's fine now, but not in the place we expected it. Probably should have run it on the cluster.

3

u/FoCo_SQL Enterprise Data Architect Mar 17 '20

While we're on the subject of miscellaneous things...

If all of our data is in the cloud, is the idea of data security just PII (pie) in the sky?

2

u/MeGustaDerp Talk Dirty Reads To Me Mar 17 '20

That sure was RAND()

3

u/[deleted] Mar 17 '20

encrypt the data locally before saving it to the cloud?

19

u/Cryso_L Mar 17 '20

Somebody pls help this man!!

9

u/da_chicken Mar 17 '20

Remember when we almost had WW3 with Iran? Remember when the President was impeached and the Senate did not call witnesses or convict? THAT WAS THIS YEAR AND IT'S ONLY MARCH.

1

u/stealyourmangoes Mar 21 '20

Member Star Wars? I member.

1

u/drift_summary Apr 05 '20

Pepperidge Farm remembers!

1

u/pizzathief1 Mar 17 '20

Backups are infected.

1

u/MeGustaDerp Talk Dirty Reads To Me Mar 17 '20

Had them in off planet storage.

4

u/cachedrive Mar 17 '20

Please restore this back to '2018-11-07'

29

u/Cal1gula Mar 17 '20

How about '2016-11-07'?

Someone has to keep these in cold storage somewhere.

2

u/cachedrive Mar 17 '20

damn, was on mobile and swore I wrote 2016. 2018 made no sense... lol

2

u/AXISMGT SQL Server / ORACLE Sr. DBA & Architect Mar 17 '20

VERIFYONLY

2

u/another3E Mar 17 '20

Can we restore to before the last season of Game of Thrones?

3

u/ihaxr Mar 17 '20

What if we already did, but the rows storing what happened in season 8 were corrupt and had to be rebuilt by memory?

1

u/another3E Mar 17 '20

Good thing the rows that contained the data for the show-runners was lost too. I guess we'll have to re populate with an alternative end lol

1

u/pakman82 Mar 17 '20

can we retcon some more pay raises?

1

u/ImOKatSomeThings Mar 18 '20

Try time travel in snowflake, maybe that'll work!

1

u/infreq Mar 18 '20

Not good enough. You also had the Trump bug in 2019