Creating BCH Files for Veritas Direct to Tape

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: )

414 reads

Blogs

Daily Coping 2 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Database Corruption, how to investigate root cause?

By

Introduction: In this article, we will discuss the MS SQL Server database corruption.  So, first, we...

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

Read the latest Blogs

Forums

SQL Server Load

By narayanamoorthy.a

Hi, The application team is pushing more than 7 lakhs records per day to...

Converting minutes to hh:mm:ss

By DaveBriCam

I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...

Interpreting Index Usage Stats on an Availability Group

By data.jedi.ken

I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers