Symptoms. In Microsoft SQL Server 2019, restoring the compressed database or log backups of the databases that have transparent data encryption (TDE) enabled may cause the following error: Msg 3241, Level 16, State 18, Line < LineNumber >. The media family on device '< backup file name >' is incorrectly formed.

Fixes a problem in which a database that has transparent data encryption enabled is marked as "suspect" if the server certificate that is used to encrypt the database encryption key is dropped. Problem occurs in SQL Server 2008 R2 and SQL Server 2008.

Log Shipping currently does not provide a way (either through UI or as a command line parameter) to set the MAXTRANSFERSIZE property. In this fix, log shipping internally sets the MAXTRANSFERSIZE to 1 MB so that effective compression can be achieved when a database is enabled for TDE.

How to earn Microsoft Rewards points. It’s easy to rack up Microsoft Rewards points and earn your way toward great rewards like gift cards, movies, games, nonprofit donations, and more. Stay signed in with your Microsoft account and you'll earn points for doing the things you already do.

You can link your social media account in one of two ways: Use the Xbox mobile app to scan the QR code. Select the Link option which will launch the Microsoft Edge app on Xbox. You can choose to link your Discord, Reddit, Steam, Twitch, or other social media account.

Enable TPM 2.0 on your PC. Published August 2021. This article is intended for users who are not able to upgrade to Windows 11 because their PC is not currently enabled with TPM 2.0 or their PC is capable of running TPM 2.0 but is not set up to do so.

Learn how to activate Windows using a product key or digital license, check your activation status, and link your Microsoft account.

For the steps to make your mobile device available to use with your verification method, see Manage your two-factor verification method settings. If you know that you haven't set up your device or your account yet, you can follow the steps in the Set up my account for two-step verification article.

Find Teams on the web at https://teams.microsoft.com. To use Teams, you need a Microsoft 365 account with a Business or Enterprise Microsoft 365 license plan.

Voice typing commands. Use voice typing commands to quickly edit text by saying things like "delete that" or "select that". The following list tells you what you can say. To view supported commands for other languages, change the dropdown to your desired language.