Restoring database in sql server is one of the important tasks database administrators have to do from time to time. Restoring a database just means to bring up a backed up copy of the database online. There are many scenarios that may require for the database to be restored from a backup such as when […]
Backing up databases is one of the tasks perform by database administrators in many organizations. The aim is to make a copy of the database with data either to restore to another server, keep it to restore in case of issues on the database, migrating application, for use on a desktop or for any other […]
This is a question one of my friends asked me today at work and l decided to write it out and share with anyone who might need it. How do you ping a database on a server to see if its in a healthy state. Assuming your writing an application and you want to test […]
Have you been in a situation where you wanted to make a backup of a database and restore to another server and realized you couldn’t backup and restore to the new location because of the size of the database? How about even after dropping or truncating huge tables and still the database size is not […]