Get the location of the recent Backup

Muestra la ubicacion del Backup mas reciente. Backup completo y backup diferencil de todas las BBDD.Get the location of the recent Backup. Complete Backup and backup diferencil of all the BBDD.

Calculate Database and Backup sizes

This script will query msdb to determine the size of data and log files for all databases, along with the average sizes of full and transaction log backups. Results are averaged over the past two weeks, but this is easily changed.

Backup database (Red Gate/Native Backup)

This is just an update which fix a small bug (0 day backup bug with SQL Backup)

Analysis Server 2005 Backup Powershell Script

This PowerShell script will connect to an SSAS instance, enumerate ALL databases, and back each one up. You can then add this to either as a Scheduled Task or as a SQL Agent job.

Backup database (Red Gate/Native Backup)

This script create a store procedure which allow you to backup databases using Red Gate SQL Backup or native SQL backup.Backups will be stored in a database named folder in a backup folder.

Customized backup scripts(Arvinder & Srivathsani)

Created By:Srivathsani M(Srivathsani_m@infosys.com)Arvinder Singh Khosla(arvinder_khosla@infosys.com)Details:The scripts gives the flexibility to create customized backups.1)It gives  the provision to give the backup files a customized name with customized time stamp.2)It allows the user to create the backup directory.3)These scripts can be used in the form of stored procedures by passing the variables defined in the script as […]

Building Automated Backups in MSDN

We write this script due we needed to implement a backup strategy in some machines with MSDE located in remote offices.In that offices there isn't Enterprise Manager, so we send the script to the office and they just execute it.Comments will be welcome

Building Automated Backups

Backups are the foundation of any well run database server, or even any computer system. Numerous articles have been written about SQL Server backups and new author Paulo Luis brings us a new twist on building automated backups using devices.

Custom Log Shipping using VB.NET

This is a first version of a custom solution for SQL Server log shipping using VB.NET 2005 and .NET Framework v.2.0. The script has to run on a server where you have SQL Server 2005 (or at least tools) installed because it uses new SMO. For some functions of the script you will have to […]

Synchronize SID with Login SID - No CURSOR