Crispin


Technical Article

Script to backup all databases

A proc which gets a list of all databases (Exluding "excluded" ones) and backs them up.The backup files are stored in the directory \DatabaseName\DatabaseName.bakUNC names are supported provided SQL Server has write access to the location.It deletes backups older than x (Current 3) days.This can be changed.Add a job to execute the script of proc […]

2003-06-26

682 reads

Blogs

Daily Coping 24 Jan 2022

By

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

Introducing ScriptDOM

By

I’ve been meaning to get a series of blog posts started on this topic....

Daily Coping 21 Jan 2021

By

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

Read the latest Blogs

Forums

SUM(CAST(....

By 2Tall

Hi to all. It has been a while since I posted. I am attempting...

How to delete records selected from another table in stored procedure

By John_Kennedy

CREATE PROCEDURE usp_DeleteEmployeeRcord ( @days Int ) AS BEGIN DELETE [dbo].[EmpMainTable] Where created <...

Multiple dates

By rafamaniac

I am new to data warehouse schema and i learning about role-playing dimensions. i...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers