(SQL) Tip of the Day: Cannot Scale Because Files Are Too Large

  • Article

Today’s Tip…

It is rare, but sometimes when you are trying to scale a SQL Azure database to a lower tier you can get an error stating your database or files are too large. A quick fix is:

image

The first query checks the sizes of the database and physical files, the last two shrink the files of your database and it’s transaction log respectively.