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 …
Category Archive: SQL Server
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:
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 …
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 …
Recent Comments