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.

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.

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.

Find help and how-to articles for Windows operating systems. Get support for Windows and learn about installation, updates, privacy, security and more.

Add flair to your email with emojis. Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Outlook 2016. Windows 10 and 11 contain a large set of emojis. To insert one: Put your cursor where you want the emoji. Hold Windows key + . (period) to open the Windows Emoji picker.

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

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.