SQL Server Backup from inside Azure VM

You can backup SQL Server databases and instances running inside Azure VM using Azure Backup. The solution leverages the SQL native APIs to take backup of your SQL databases. When you specify the SQL Server VM that you want to protect and query for the databases in it, the Azure…continue reading →

Sharepoint 2013/16 and WSS_Logging DB

Sharepoint gathers usage and health data to database called WSS_Logging. By Default retention period is 14 days. If You want to make it lower, lets say 2 days use the below oneliner for it. [crayon-603dc986c6738529001769/] And then just a quick hint for releasing space from Sharepoint WSS_Logging database. Use the…continue reading →

User has db_owner my mistake.

Hi, When you are trying to remove user from a database, you will get: The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) There is a easy fix for this. First see what Schemas the user principal own's: USE DATABASENAME; SELECT…continue reading →

Install SQL when reboot is pending

Hi, First of all. There are some instructions that say you should remove pending renames from registry. Don't do it. Just type text below from an administrative command prompt. setup /ACTION=install /SkipRules=RebootRequiredCheckcontinue reading →

Transfer SQL Logins and their passwords.

Hi again, Done this multiple times, but thought it would be wisdom to share it. Remember this wont be necessary in SQL 2012 and higher because they save users and password directly to the user database not the master database. 1. Collect Logins from old server. USE master GO IF…continue reading →