This script was written to solve a problem where we needed to dynamically create bch files for Veritas Backups direct to tape backups. We needed to parse the sysdatabases daily and create the bch files that veritas would use to backup each server and database. This SQL Script uses xp_cmdshell to call a windows shell […]
2007-10-02 (first published: 2007-06-18)
414 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By nelsonaloor
Introduction: In this article, we will discuss the MS SQL Server database corruption. So, first, we...
I have held various certifications through my DBA career, from CompTIA A+ certification back...
Hi, The application team is pushing more than 7 lakhs records per day to...
I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...
I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...
Ask SSC