SQLServerCentral.com Scripts tagged Backup

Backup all SSAS databases using TSQL

Thu, 28 Mar 2013 06:00:00 UT

Enumerates and backups all SSAS DB's

Backup history details EMAIL (past 24 hours) in HTML format

Wed, 27 Mar 2013 06:00:00 UT

Get backup status email daily to your inbox in HTML format.

Dynamic Transaction Log Backup

Fri, 16 Nov 2012 07:00:00 UT

Backup up all transaction logs based on sys.databases.

Dynamic Database Backup

Wed, 21 Nov 2012 07:00:00 UT

Backup up all databases based on sys.databases.

Last Backup Taken, or Not

Thu, 24 May 2012 06:00:00 UT

Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.

Task Progress

Tue, 10 Apr 2012 06:00:00 UT

Query to check estimated time of a task completion. Viz, alter index, backup, restore, etc.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

UP_COMPACTA_COPIA

Mon, 17 Oct 2011 06:00:00 UT

I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.

NetApp Dynamic Backup Script

Tue, 09 Aug 2011 06:00:00 UT

TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases

SQL DBAdmin toolbox - Part 1: Restore single database

Fri, 10 Jun 2011 06:00:00 UT

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.