Tag Archive: SQL Server

Mar 11 2020

Migrating the WSUS database from WID to SQL Server

Running WSUS with the Windows Internal Database (WID) has been working great for us, for years, but if we want to have the database on a separate volume, if we want better performance, better management tools and especially being able to back it up using our internal or cloud backup tool, then we need to …

Continue reading »

Aug 15 2013

Creating an Active/Pasive SQL Server Failover Cluster

In a production environment you can’t afford downtime, well…not for hours anyway. If one of the servers stops or crashes, most of the applications in that production environment will stop working. Off course, you have a recovery plan. But what if those applications are using a database, and the database server crashes ? Your recovery …

Continue reading »

Apr 13 2013

Move a SQL database from one server to another server

Sometimes you need to move/migrate your SQL database(s) from one server to another, or just copy that database from a production environment to a test one, or vice-versa. Maybe you want to upgrade you SQL environment to the latest version, and a migration is preferred instead of in-place upgrade because of a few things, like:

Continue reading »

Feb 02 2013

How to install SQL Server 2012 on Windows Server 2012

Now that both, Windows server and SQL server 2012 are out, I thought¬†I give it a try to see how they match up. The installation of SQL server in this guide is a simple one, meaning there is not going to be an installation inside a Failover Cluster, and all the SQL features will be …

Continue reading »

Nov 04 2012

How To Install SQL Server 2008 R2 on Windows Server 2008 R2

Now days, there is barely an application that is not using a database, they can use an internal one or a third-party product like Microsoft SQL server. SQL server comes in more than one edition, and if you are a small business you can use the free edition of this product; off course it has …

Continue reading »