Technical Article

Perform an action when a file exisits

Script to check whether a file exists with todays date and performs an action based on whether the file exisits or not. We use this to check whether backups have completed from another SQL Srver and if they have completed we restoe on a server used for management information

You rated this post out of 5. Change rating

2002-01-09

2,052 reads

Blogs

The trade-offs associated with low-code solutions

By

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Monday Monitor Tips: Looking Back in Time

By

Often we find out about a problem reported by a customer after the incident...

Can You Tell Why a Plan Didn’t Go Parallel?

By

Let’s face it, most of the time, you probably don’t want your SQL Server...

Read the latest Blogs

Forums

SMO Company in India

By codeincsolutions

Code Inc Solutions is a top-tier SMO Company in India that truly knows how...

Social Media Optimization Company in India

By codeincsolutions

Code Inc Solutions is a top-tier Social Media Optimization Company in India that truly...

Is there a way to determine an Azure Data Factory Trigger's "next run time"?

By Orlando Colamatteo

Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...

Visit the forum

Question of the Day

The Table Backup

I run this code in SQL Server 2022. What happens?

BACKUP TABLE beercount TO DISK = 'beercount.bak'
 

See possible answers