MSSQL Storage

This pageset describes Microsoft's' MSSQL database system. The screens are split by

MSSQL System Databases

A description of the SQL system databases, and also the two sample databases that come supplied with an SQL server. Also includes instructions on how to move system databases

MSSQL User Databases

This page discusses the different physical files used by MSSQL User databases, maximum file and database sizes, how to manage database growth, and how to group files into Database Groups

Backup and Recovery

How to backup and recover SQL databases using the SQL Server Management Studio. How to rebuild and recover the master database

Shrinking a database

MSSQL databases can grow automatically as required, but if data is deleted from them, they do not automatically shrink. If you have a database that is wasting a lot of space, then you need to reclaim that space by shrinking it. This page details how to shrink a database.

MSSQL Replication

MSSQL databases can be replicated between mobiles, servers, buildings or even continents. This section discusses how replication works

MSSQL Continuous Availability

Database snapshots, clustering and mirroring

Use the the links above, or left hand frame to navigate between the pages.

back to top

By entering and using this site, you accept the conditions and limitations of use