page contents
Tag Archives: database

SQL Server Compatibility Levels

Have you ever wondered what versions of SQL Server related to the compatibility levels? This article will show you the levels and also how to change existing databases to different SQL releases. This is a list of all SQL Server Compatibility Levels: Product Database Engine Version Compatibility Level Designation Supported Compatibility Level Values SQL Server […]

Leave a comment Continue Reading →

Moving the System Databases in SQL Server 2008R2

One of the more common tasks you will encounter in moving a system or user database from one physical location to another location. For example, Microsoft recommends that we place our backups, data files, transaction logs and tempdb files on four separate drives. However, the installer by default will place the system databases (Master, Model […]

2 Comments Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.