MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter






























Microsoft SQL Server Articles, Tutorials, News, Tips & Tricks




Steps to Install SQL Server 2008 R2 on Windows Server 2008 R2

This article describes the steps to install a standalone instance of SQL Server 2008 R2 on Windows Server 2008 R2

Why an SQL Server Database from a higher version cannot be restored onto a lower version?

If you are trying to restore a database on an SQL Server 2005 or a lower version from the database backup which was performed on an SQL Server 2008 instance then it will fail. In this article we will take a look at the reasons why an SQL Server Database from a higher version cannot be restored onto a lower version of SQL Server.

How to identify if the database was upgraded from a previous version of SQL Server

Is there an easy way to identify whether the database was upgraded from a previous version of SQL Server or it was created on the existing instance of SQL Server? In this article we will go through the steps to identify whether a database was upgraded from a previous version of SQL Server or it was created newly on the existing instance.

How to repair a Suspect Database in SQL Server

This article describes the steps to recovery a database which is marked as SUSPECT.

Steps to Rebuild System Databases in SQL Server 2008

This article demonstrates how to rebuild system databases in SQL Server 2008.

How to Get Exclusive Access to SQL Server Database

In this article we will take a look at how database administrator can leverage ALTER DATABASE Commands to get exclusive or restricted access of a database.

Understanding SQL Server Recovery Models

This article describes about different types of SQL Server recovery models and also discusses difference between Simple, Bulk Logged and Full Recovery Models.


How to Change Default SQL Server Backup Folder Settings in SQL Server

This article demonstrates how to change the Default SQL Server Backup Folder in SQL Server 2008 Using Policy Based Management Feature.

How to Change Default location of SQL Server Data and Log files in SQL Server

This article demonstrates how to change the default file location of SQL Server Data and Log Files.

How to Enforce Password Policies and Password Expiration Policies for SQL Server Logins

This article demonstrates the steps to create an SQL Server Login which enforces password policies and password expiration policies feature that is available in Windows Server 2003 and later versions to passwords which are used inside SQL Server 2005 and higher versions.

How to Automate Backup of Analysis Services Database Using SQL Server Agent Job

This article demonstrates how to create an SQL Server Agent Job to backup an analysis services database.

How to Restore an Analysis Services Database Using SQL Server Management Studio (SSMS)

This article demonstrates the steps which a database administrator needs to follow to restore an analysis services database.

How to Backup an Analysis Services Database Using SQL Server Management Studio (SSMS)

This article demonstrates the steps which a database administrator needs to follow to backup an analysis services database.

How to Delete Duplicate Records from an SQL Server Table

This article demonstrates how to take advantage of Common Table Expression (CTE) feature of SQL Server 2005 to delete duplicate records from a table.

How to Audit SQL Server Logins

This article demonstrates how a database administrator can easily enable auditing in SQL Server for logins.



Share this Article





Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips



Latest SQL Server Tips