Moving database from On premise to Azure

It may be that you are trying to move your DB from on premise to Azure and using ALTER DATABASE command. Once you make the metadata change using ALTER DATABASE and then move the physical file to AZURE, the DB fails to come online with the following error message: 2014-05-15 04:31:59.370 spid26s      Error: 5120, Severity:…

0

Master DB restore & Service Master key

If we don’t have a recent master backup and have to make use of the files from the DR server, then as long as our target instance matches the path and build requirements we can restore master and bring it up. If the build is different , we will get an error. If the path…

0