Creating Backup Devices
This Stored Procedure create backup devices for all user databases. You can customize path, name standard and type of device.See Creating Job Backup
2002-09-12
514 reads
Creating Job Backup
This Stored Procedure create backup job for all user databases. You can customize SQLAdmin operator.See Creating Backup Devices
2002-09-12
837 reads
Blogs
Daily Coping 2 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Database Corruption, how to investigate root cause?
By nelsonaloor
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?
I have held various certifications through my DBA career, from CompTIA A+ certification back...
Forums
SQL Server Load
Hi, The application team is pushing more than 7 lakhs records per day to...
Converting minutes to hh:mm:ss
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
I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...
Ask SSC