I was just exporting some brand new sprocs from my dev sql server to my production sql server.
When doing it, I got an error and when I looked at the error it said that it couldn’t drop a particular TABLE for some reason.
I wasn’t dropping tables! What is it doing? Egads!
Now I have to go through the application to make sure that nothing got whacked (yes we have backups every 6 hours..)
update: yes tables got dropped … thank goodness for our backups (every 6 hours). Though I explicitly only chose sprocs as objects to be exported, we still have figure out WHY this happened. Big thanks to my friend and SQL Server Guru, Roman Rehak! And I should probably go to the local SQL Server User Group meeting tomorrow night – the topic is BackUp and Restore!!
Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!