2019-05-03 (first published: 2015-05-15)
1,572 reads
SQl Hunt
- Interests: Like to make friendship with people.
Copy Backup Files to Remote Shared Location and Delete them periodically
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)
1,979 reads
Create EndPoint
Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett
2019-05-03 (first published: 2016-09-16)
2,496 reads
2019-05-03 (first published: 2015-05-05)
2,108 reads
Delete Backup Files From Default Backup Location
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)
618 reads
Delete Backups Older than N Days
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,098 reads
Delete SQL Instance name from default backup location
IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.
2019-05-03 (first published: 2015-03-23)
700 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2019-05-03 (first published: 2015-06-03)
1,585 reads
Enable Email Notification to all SQL Jobs
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2019-05-03 (first published: 2016-09-20)
984 reads
Execute All .SQL Script easily
If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.
2019-05-03 (first published: 2015-05-18)
2,468 reads
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Error in SQL Server Management Studio launcher
Guys, good night! I have a situation in my SQL Server Management Studio where...
Just upgraded SSRS from 2016 to 2022
I just upgraded SSRS from 2016 to 2022. This is my first time doing...
Weekly sales report
I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...
Ask SSC