Bimal,

Thanks for the clarification.  I went so far as to examine the properties of the drive and found that after dropping the snapshot, that available space went up on the...

Bimal,

Thanks for the clarification.  I went so far as to examine the properties of the drive and found that after dropping the snapshot, that available space went up on the...

A snapshot database is NOT <= Original.  It will be = Original minus the log.

See proof below.  Commands in black, results in red.

exec sp_helpdb UPSRC   -- show size...

It is not true that a snapshot consumes less disk space than a disk backup.  It could actually consume more.  The space taken by the snapshot database is EXACTLY the...

PRINT 'Author : Ricky Petilla / Dave Yoder'

PRINT 'Purpose: Identify drives at are below 500 MB free space.'

PRINT 'Written: 2003/07/28 Version 1.0'

use RBSAVE

/*

create table psdrivesfreespace

(

ASOFDATEdatetime,

MACHINEvarchar(15),

DRIVEvarchar(2),

MBvarchar(7)

)

*/

set nocount on

create table...

I would like to see an "auto-format" function added to Query Analyzer. Quest makes a utility 'FormatterPlus' - but it only works for Oracle.

Interesting concept - But difficult to read and I have found several problems with the code (On SQL2k sp2 it would not run without some fixes.)

You need to used the BE feature "redirected restore". The dialog boxes will allow you to specify a different (single) drive to use if the original can not be...

We have a 60+GB database with near 24x7 availability. We have a very short 5 minute window between 9:25 and 9:30 pm where we want to have a "snapshot"...