Backup and restore

Trim Backup Files

  • Script

This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]

1 (1)

2001-09-12

1,467 reads

Blogs

Daily Coping 16 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Running a .sql script file.

By

As with all programming tasks there are a number of ways to do something,...

sp_RestoreScript 1.9 – a dirty little bug squished!

By

It look like we had a little bug in sp_RestoreScript that was putting a...

Read the latest Blogs

Forums

Multiple instance on SQL server 2017 with VS 2019.... ERROR 26 on Visual Studio

By Charitto95

I have a system with multiple clients and each one in different virtual machines,...

SSRS 2017 How to check which SSL cert is bound

By webrunner

Hello experts, I need to update the SSL certificate on our SSRS 2017 instance....

Rebuild index

By Chitown

I have a table which is partitioned (Total 10). The table is 1.6 TB...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers