This is the SP I schedule to do diff backups on the DB's that I can. I still need to add errorchecking to see if there is a full available before I do a diff. I'll add that when I get time. This stored procedure is designed to take 4 parameters @bksrv : This is […]
2001-09-06
1,536 reads
This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user […]
2001-09-06
4,590 reads
A handy dandy proc that can be used to zip up a backup file to location specified. Also called from a backup script to automate the compression of all backups using PKZip command line utility. Make sure pkzip is in the path and found by the shell prior to using this script.
2001-08-20
3,732 reads
2001-08-08
2,588 reads
This procedure will BCP out all data in a table. The format is designed to be used with the dbsp_bcp_in stored procedure to import the data back into a server.
2001-08-08
3,939 reads
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Apologies if this is posted in the wrong forum, but I am trying to...
Hello all, I have a linked server created on an instance which only has...
Hi, I want to find all the tables name under a database where tables...
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers