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
573 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
442 reads
Blogs
Using SQL Compare for One Procedure
By Steve Jones
A customer recently was concerned about the time to run SQL Compare for a...
Daily Coping 11 June 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Secondary Database and Tiers
By Arun Sirpal
On the theme of failover groups let’s do a quick recap on my environment....
Forums
Tracking, Privacy, and Lots of Data
Comments posted to this topic are about the item Tracking, Privacy, and Lots of...
SQL Servers performance issues
2019 Standard and enterprise. Higly generic question here. Under similar setups baring versions do...
Distributed Availability Group setup for DR Standalone SQL server
Hi Team, We have primary DC which is having 3 nodes cluster and implemented...
Ask SSC