Nothing is Bug Free …

Share reusable code, script, component. Reusable Database scripts. Different kinds of automation tools like SSIS, Batch ... please write a Comment to do batter ...

Wednesday, September 25, 2019

Check Who has Server Level Access, SQL Server

Using below two SQL queries we can retrieve who has what access on the database server. I have divided it into two-parts 1. Role access [...

Tuesday, September 24, 2019

Shrink LOG files automatically, SQL Server

Use below script to shrink T-LOG files. This script will shrink the log file which is larger than the value of the variable " @LOG_SIZE...

Backup All Databases, SQL Server

Using the below script we can take all databases backup with one command!! You can check my other post BACKUP STATUS to know the current ...

Monday, August 19, 2019

Check Database backup History, SQL Server

Always I like to use below SQL to find the backup history either DB backup or LOG backup. this is very handy and useful. By this SQL you c...

Thursday, April 18, 2019

Is Backup/Restore Database/Log running in SQL Server?

Sometimes it's very important to know whether database or log backup or restore is running or not! in a word, if we need to check the ...

View web version

Powered by Blogger.