Tag: Databases

Create a test copy of a live website with database back-end

This guide describes the process followed to create a copy of a logging system called TalkBox, however the steps should be similar for any database system with a web front-end. Obviously you shouldn’t make any changes to a live system.

Posted in Guides Tagged with: ,

Remove a database mirror

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. To remove a mirror you need to be logged in to the Principal server, and authenticated against the database instance. You then:

Posted in Guides Tagged with:

Restore a mirrored database

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. It assumes the databases are in a synchronous mirroring configuration with no witness server and that you are using an account with Admin

Posted in Guides Tagged with:

Backup a database

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. In this guide the database server is Server01 and the database is called Database9.  1. Log on to Server01, open Microsoft SQL Server Management Studio and connect

Posted in Guides Tagged with:

Kill database processes

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. If you are trying to perform a task on a database and are getting a message that the database is

Posted in Guides Tagged with:

Delete a database which has been set up for mirroring

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. It assumes the databases are in a synchronous mirroring configuration with no witness server and that you are using an account with Admin

Posted in Guides Tagged with:

Fail a database over to a mirror server in the event of a DR Test

This guide was created with Microsoft SQL Server 2008 in mind, but should work for any version of SQL Server. It assumes the databases are in a synchronous mirroring configuration. In this guide the database is called Database9. 1. Log

Posted in Guides Tagged with: