Kevin Pirnie' Articles

This procedure and script are meant for use in situations where your SQL server may not have SQL Agent installed. Whether it is because it's SQL Express being use, or because it simply was not an option at the time of install. First thing you will need to do is login to the SQL server using SQL Management Studio.  Make sure your login is able to create stored procedures at the system level, and add the following to the 'master' database USE [master] GO /****** Object: StoredProcedure [dbo].[sp_BackupDatabases] Script Date: 08/17/2011 10:55:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Microsoft -- Create date: 2010-02-06 -- Description: Backup Databases for SQLExpress -- Parameter1: databaseName -- Parameter2: backupType F=full, D=differential, L=log… Read More