I'm experiencing a rather bizarre problem that baffles me.
I have a production DB that I backup from our production box and then restore to our Dev server for some testing.
Yesterday I had to deploy a new version of a stored proc to the production DB. This new version of the stored proc only had some very minor changes. Today I took a backup of the DB and restored it to our dev box. When I diff the DB (with RedGate SQL Diff) it shows a difference between the two DBs for that proc. The newly restored DB on the dev server has the old version of the procedure!
If I go into the object explorer and script out the proc, the old version is in fact what comes out from the newly restored DB (on our dev box). If I do the same on our production machine, the new version of the proc is there.
And it's not just that one proc. There are a few others as well. Some of which I updated weeks ago.
It seems that the backup didn't capture the new version of the proc?
Has anyone ever experienced this?
This is the backup command I use.
BACKUP DATABASE DbName
TO DISK = C:\SomePath
NAME = SomeBackupName,
DESCRIPTION = SomeBackupDescription,
STATS = 10;
Any thoughts would be most appreciated.