New columns on existing table are dropped the next day
Has anyone encountered an issue like this? I cannot find anything searching. Troubleshooting is not fruitful yet
New columns created on existing tables will disappear the next day (ie. ALTER TABLE <name> ADD <column and metadata>)
New tables created within a given DB will persist the next day/ongoing, however
Target DB is set to SIMPLE recovery. DB is in autocommit mode
Running SQL Server on Azure VM
Thankyou
Has anyone encountered an issue like this? I cannot find anything searching. Troubleshooting is not fruitful yetNew columns created on existing tables will disappear the next day (ie. ALTER TABLE <name> ADD <column and metadata>)New tables created within a given DB will persist the next day/ongoing, howeverTarget DB is set to SIMPLE recovery. DB is in autocommit modeRunning SQL Server on Azure VMThankyou Read More