Browsing articles from "July, 2015"
Jul
24
2015

Shrink Data file failed with Error 3140

While shrinking a large (950GB) database file to move data to a secondary NDF, got below 3140 error, it is a normal error occurs while shrinking files of that capacity, please find resolution below,   Error:   Environment: SQL Server 2005 ENT. ed.   Issue: Data file shrink fails for large data file size with Error: 3140   Fix: The following example query truncates the primary data file in the AdventureWorks2008R2 database. The sys.database_files catalog […]

Jul
20
2015

SQL server setup failure – Updating permission setting for file E:\**** failed

While re-installing SQL server, got below error,       To fix this execute below commands with elevated access in command prompt so that permissions get applied to respective path,   Eg: takeown /F c:\Windows\system32\drivers /D y /R    In our scenario commands are provided below:   Here path is “F:” which is a parent folder.   takeown /F F: /D y /R   cacls F: /E /T /C /G “<<<user_AD_account_name>>>“:F

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

July 2015
M T W T F S S
« Jun   Aug »
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: