Viewing 14 posts - 31 through 45 (of 45 total)
In the interim you could:
select BackupDate = convert(varchar(10),backup_start_date, 111), SizeInGigs=
CAST(round(backup_size/1073741824,4) AS decimal(18,4)),
backup_size AS [Raw backup_size],
CASE TYPE
WHEN 'D' THEN 'Full'
WHEN 'F' THEN 'Filegroup'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Log'
ELSE 'Unknown'
END AS...
May 20, 2011 at 7:07 am
March 14, 2011 at 4:07 am
I did note this in the Forum if of any use... http://www.sqlservercentral.com/Forums/Topic672649-391-3.aspx
December 10, 2010 at 2:53 am
If you need that space back, then you need that space back. A warning on the side effects and gentle background automated 'heal'.
December 10, 2010 at 2:07 am
If you write it down and someone observes and manages to login as you, then you have a potential repudiation problem (means that you may have to prove that what...
November 8, 2010 at 8:56 am
A few observations. When I was unemployed, the only real skills I had were I(C)T type so that limited my options. IT has always been metamorphic (five years...
May 20, 2010 at 2:10 am
Right on. If I recall correctly the Business Studies book says these type of meeting should always be objective and not subjective.
At my previous company pay adjustments (if any)...
May 11, 2010 at 1:49 am
Those who might use 'The REPLACE_Nth_CHAR Function' might also be interested in STUFF (deletes a specified length of characters and inserts another set of characters at a specified starting point).
August 11, 2008 at 5:27 am
Viewing 14 posts - 31 through 45 (of 45 total)