Administration

SQLServerCentral Article

Using Different Techniques for SQL Server Automation

  • Article

Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.

5 (2)

You rated this post out of 5. Change rating

2004-08-02

17,390 reads

Blogs

Friday Flyway Tips: Chaining Commands for State-based Deployments

By

One of the cool things I’ve seen with the new Flyway CLI is that...

A New Word: Querinous

By

querinous – adj. longing for a sense of certainty in a relationship; wishing there...

How to clear the SSMS cache?

By

How to clear the SSMS cache? If you are reading this,...

Read the latest Blogs

Forums

I need help accessing my local SQLExpress

By Rod at work

My PC has been causing me problems for months. I've told my desktop support...

MDX SSAS Calculated measure for last totals + turnovers

By IvanMarkevich

I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...

display bytea image

By Bruin

I moved a table from MsSql to Postgresql that had a field defined as...

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers