jasona.work (7/11/2014)

---

What a way to come back from a long(-long) weekend...

The other DBA (more a developer with DBA knowledge) in trying to get a bunch of Sharepoint DBs backed up to file with the current production versions, had the backup Admin (3rd party product) restore the DBs from Prod to QA. Problem is, he (and the backup admin) both thought it would just restore the files...

So, I've spent most of yesterday and today getting the MDFs and LDFs back in the proper homes on the server. On top of that, last week we lost our Oracle DBA, so now (again) I get to pretend to be an Oracle DBA for the next couple weeks...

🙁

Even more fun, one of the DBs that was restored (not sure how this got added to the list, might've been a mis-click in the backup software) MSDB (again in QA, thankfully) was *also* restored, and to the wrong location...

So I'm holding off on moving the files for MSDB until everything else is fixed, but it needs to be done as it's now living on some temp storage that was added for a migration project...