Backup a database
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
570 reads
Script to export Stored Procedures
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
435 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