MS SQL
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...
MS SQL
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...
Blog, MS SQL
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...
Uncategorized
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...
Recent Comments