FREE Microsoft eBooks

Microsoft Senior Sales Excellence Manager – Eric Ligman posted a list of almost 300 FREE Microsoft eBooks. You can download them all from hos blog at the following address:

Migrate database to a lower version

It is not supported to downgrade a Microsoft SQL Server by using the detach/attach or backup methods. However, it it possible to script data from the upgraded database and then import it into a new database in the lower version of SQL Server. A good description of this can be found on the following page:

Check Database Size

There is a standard SQL report that shows how much space a database is using. In SQL Server Management Studio for SQL Server 2008 R2 and newer, right-click on the database you are interested in and select Reports->Standard Reports->Disk Usage.

There is a good description of this report, including information about how to resize a Operations Manager database in the blog:

Create your website with
Get started