Verify SQL Backups With SQL Powershell
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
2016-04-25
5,040 reads
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
2016-04-25
5,040 reads
Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.
2015-12-17
5,117 reads
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,307 reads
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
722 reads
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2019-05-03 (first published: 2015-06-04)
635 reads
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2019-05-03 (first published: 2015-06-01)
2,037 reads
2015-06-15 (first published: 2015-05-22)
1,669 reads
2019-05-03 (first published: 2015-05-15)
1,583 reads
Wrote the script to take compressed backup with combining many other features.
2019-05-03 (first published: 2015-04-29)
1,024 reads
SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED,
IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.
2019-05-03 (first published: 2015-03-16)
5,433 reads
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I have a simple table with 5 columns as follows with about 80,000...
hi everyone I have a SP that is run in SSIS. That particular SP...