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
516 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
845 reads
Blogs
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Do Full Backups Break Log Shipping?
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
Daily Coping 15 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSRS Zero-Day patching?
Hello all, I've been tasked (rather randomly) with finding out if there is somewhere...
Informatica -SQL Error
We get a sql connection from host informatica server and the query runs in...
Last Successful Completion Date for SQL Job
I am trying to write a query to get a list of all SQL...
Ask SSC