Restore MDF file to New Database

Execute below script to restore any MDF and LDF files to new Database.

USE [master]

GO

CREATE DATABASE DemoDB ON

( FILENAME = N'I:\MSSQL\DATA\DemoDB.mdf' ),

( FILENAME = N'K:\MSSQL\Logs\DemoDB_log.ldf' )

FOR ATTACH ;

GO

SQL to Shrink LogFile after Truncating Records

Below SQL helps you to shrink a DB grown due to truncating of records from tables regularly:

USE DemoDB;

DBCC SHRINKFILE ('DemoDB_log',0,truncateonly)

SSAS Error: No Mapping between Account Names and Security IDs was Done

We may come across the below error mostly while we are deploying SSAS cube in to one server:

It is because of difference in domain between development server and deployment server. In that cases Goto Roles --> Membership tab, and remove non-supportive members from the role.