Our Blog
What some of our Techs dealt with on the job.
How to backup all MSSQL Databases in a server with a Script
You could use SQL Server Management Studio to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach. With the use of T-SQL you can generate your backup commands and with the use of cursors you can cursor through all...
Copy maintenance plans to a different server
Question: Is there a way to copy maintenance plans from one SQL Server 2012 to another? Both servers are not accessible via the same copy of Management Studio at the same time (on different networks). Yes: Go to the server where the jobs exist, in Management Studio's...
Disk Space Monitoring – Detecting Low Disk Space on SQL Server
How to detect if the disk space is running low on SQL Server. There are two different ways to do the same. I personally prefer method 2 as that is very easy to use and I can use it creatively along with database name. Method 1: EXEC MASTER..xp_fixeddrives GO --Above...
How to Remove One Standby Database from a Data Guard Configuration
Find the LAD (log_archive_dest_n) and the db_unique_name for the Standby that is being removed: show parameter log_archive_dest_ Take note of those that have values such as: log_archive_dest_1 string LOCATION=+RECOC1 VALID_FOR=(AL...
How to Resolve In-Doubt Transactions
What is an "In-Doubt Transaction"? The two-phase commit mechanism ensures that all nodes either commit or perform a rollback together. What happens if any of the three phases fails because of a system or network error? The transaction becomes in-doubt. Distributed...
Find and Kill MSSQL Dead Locks or Blocking Processes
Finding and Terminating SQL Server Blocking Processes - Dead Locks in MSQL We can free or release or remove or delete or check all locks on the sql server 2008,2012 and 2014 objects like table etc by killing the process id which is keeping the locks on the objects...
Oracle Patches and Application
Patching is one of the most common task performed by DBA's in day-to-day life . Here , we will discuss about the various types of patches which are provided by Oracle . Oracle issues product fixes for its software called patches. When...
BE WISE – Let Wisdom be yours
1. 👉No matter how beautiful and handsome you're just remember Baboon and Gorillas also attract tourists . ✌Stop Boasting✌ 2.👉No matter how big and strong you are, you will not carry yourself to your Grave . ✌Be Humble✌ 3.👉No matter how tall you are, you can never see...
Recent Comments