Category: Troubleshooting
Database Accidents : Unwanted Restore

Database Accidents : Unwanted Restore

Number of times, while working as a DBA many accidents happen. Most common of them is when a database is restored without checking if a backup is available or not. As a thumb rule ...

READ MORE +
0
Fragmentation of Log files and VLFs

Fragmentation of Log files and VLFs

In a SQL server, having multiple log files does not have any performance benefits as the log files are written sequentially. The log files can have external (disk level) ...

READ MORE +
0
What is SlipstreamMediaInfoCheck?

What is SlipstreamMediaInfoCheck?

Checks whether the language of the original media is the same language as the specified service pack.

READ MORE +
0
What is RS_IsDotNet3_5Installed?

What is RS_IsDotNet3_5Installed?

This rule determines if the Microsoft .NET Framework 3.5 Service Pack 1 is required on the system, based on the features you selected and whether Microsoft .NET Framework 3.5 ...

READ MORE +
0
What is DEV10RTMDetected?

What is DEV10RTMDetected?

This rule determines whether the computer has any prior installations of Visual Studio 2010 that might require Service Pack 1 update.

READ MORE +
0
What is ServerCoreNetFxCheck?

What is ServerCoreNetFxCheck?

Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation.

READ MORE +
0
What is PowerShellCheck?

What is PowerShellCheck?

Checks whether Windows PowerShell 2.0 is already installed on system. Windows PowerShell is needed by some SQL Server features.

READ MORE +
0
What is InternetConnectionToNETFX4DownloadSite?

What is InternetConnectionToNETFX4DownloadSite?

SQL Server media for Express packages does not include Microsoft .NET Framework 4.0 package. If Microsoft .NET Framework 4.0 is not already installed on the computer, SQL Server ...

READ MORE +
0
What is DotNet35OrInternetConnectionCheck?

What is DotNet35OrInternetConnectionCheck?

If you are installing SQL Server on Windows 8 or higher version of Windows, Microsoft .NET Framework 3.5 might not be installed by default. In order to ensure successful ...

READ MORE +
0
What is ASIsValidEditionForDeploymentModeCheck?

What is ASIsValidEditionForDeploymentModeCheck?

Checks whether the SQL Server edition supports the currently selected Analysis Services server mode.

READ MORE +
0
What is SSMS_IsInternetConnected?

What is SSMS_IsInternetConnected?

Verifies that the computer is connected to the Internet. When a Microsoft .NET application like Microsoft Management Studio starts, there maybe be a slight delay while the .NET ...

READ MORE +
0
What is FusionRebootCheck?

What is FusionRebootCheck?

Checks if a computer restart is required because of broken fusion ATL. A pending restart can cause SQL Server Setup to fail.

READ MORE +
0