Solved

add a named Column to where statement

Posted on 2009-05-19
15
239 Views
Last Modified: 2012-05-07
See attached text file.  I am trying to add in a named colum to my where clause to make it work correctly.  All of this select goes into a datagrid for presentation.
Help.txt
0
Comment
Question by:kdeutsch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 3
  • +1
15 Comments
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24421704
It looks like you're trying to say when both your case condition is met and when your substring > 0.  If this is the case, try the following snippet.

SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
  and at.AUTH_DOC_POSN_TITLE like '%(%)%'
  and substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END > 0
Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

Open in new window

0
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24421733
The other way I could read your question is that if auth_doc_posn_title is like '%(%)%' then you want to check the substring and include >0, otherwise if auth_doc_posn_title isn't like that, don't bother checking the substring and include it anyway.  If this is what you're looking for, try the below instead.

SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
  and ((at.AUTH_DOC_POSN_TITLE like '%(%)%' and substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END > 0)
   or (at.AUTH_DOC_POSN_TITLE not like '%(%)%'))
Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24421818
I keep getting an error of incorrect syntax near else on line 22.
I tired something like taht before but received 0 records.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 42

Expert Comment

by:pcelba
ID: 24421845
The CASE structure is allowed in WHEN clause, so you should look at its values first and then you may decide if it works or not.
0
 

Author Comment

by:kdeutsch
ID: 24421869
Hi I provided some data, it might provide more insight.
Help2.txt
0
 
LVL 42

Expert Comment

by:pcelba
ID: 24421892
You have duplicate END in your case, try this WHERE:

where      Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
and       case when at.AUTH_DOC_POSN_TITLE like '%(%)%'
        then substring(at.AUTH_DOC_POSN_TITLE,
                       1 + charindex('(', at.AUTH_DOC_POSN_TITLE),
                       charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1))
        else '0' end - at.ASGN_STR > 0
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24421926
You can put that in a CTE expression. Try this:

;with FilterVAC as (
SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT 
		when 'E' then 'M' 
		when 'W' then 'M' 
		when 'O' then 'M' 
		else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC(case when at.AUTH_DOC_POSN_TITLE like '%(%)%' 
					then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', 						at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) 
				else '0' end ) = 0 THEN 0 
	ELSE 
		case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg
)
select * from FilterVac
where VAC > 0

Open in new window

0
 
LVL 42

Expert Comment

by:pcelba
ID: 24421969
You can use your select as subquery:
SELECT * FROM (
SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726') SUBQ
WHERE SUBQ.VAC > 0

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24421988
pcelba
Tried taht and it always comes up with zero records,  from the sampling I showed it should come up with a few.

ralmada, these are the errors on this script
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ';'.
Msg 156, Level 15, State 1, Line 29
Incorrect syntax near the keyword 'Order'.
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24422019

;with FilterVAC as (
SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
)
Select * from FilterVac
where VAC > '0'
Order by at.UPC, at.Auth_Para_Dsg, at.Auth_Line_Dsg

Open in new window

0
 
LVL 41

Expert Comment

by:ralmada
ID: 24422027
sorry
;with FilterVAC as (
SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
)
Select * from FilterVac
where VAC > '0'
Order by UPC, Auth_Para_Dsg, Auth_Line_Dsg

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24422086

ralmada:  Still getting this erro, tried to remove but brings more error, i tired single quote on select asl well with no result.

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ';'.
0
 
LVL 41

Accepted Solution

by:
ralmada earned 250 total points
ID: 24422120
Are you SQL 2005? ";with" only works in SQL 2005. If not try this:


Select * from (
SELECT	at.UPC as UIC, 
	ut.Addr_City as City,
	at.Auth_Para_Dsg as PARA, 
	at.Auth_Line_Dsg as LINE, 
	at.GRADE, 
	substring(at.POSC, 1,4) as DMOS,
	case at.AUTH_PERS_IDENT when 'E' then 'M' when 'W' then 'M' when 'O' then 'M' else 'I' end GENDER, 
	at.AUTH_STR,
	CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end  END AS OS,
	at.ASGN_STR,
	at.AUTH_STR + CASE WHEN  ISNUMERIC( case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end ) = 0 THEN 0 
	ELSE 
	case when at.AUTH_DOC_POSN_TITLE like '%(%)%' then substring(at.AUTH_DOC_POSN_TITLE, 1 + charindex('(', at.AUTH_DOC_POSN_TITLE), charindex(')', at.AUTH_DOC_POSN_TITLE)  - (charindex('(', at.AUTH_DOC_POSN_TITLE) + 1)) else '0' end - at.ASGN_STR END AS VAC,
	case substring(at.DOC_NBR, 1, 2) when 'NG' then 'TDA' else 'MTOE' End as UNIT_Type,  
	case st.strStat when 'L' then 'Locked' when 'C' then 'Critical' Else '' end as UNIT_Stat
FROM    PERS_UNIT_TBL as ut Inner join
	PERS_AUTH_STR_TBL as at on at.UPC = ut.UPC Left Outer Join
	DotNet.dbo.tblStatUic as st on st.strUIc = at.UPC
where	Substring(at.grade, 1,1) = 'E' and at.UPC = '77726'
) FilterVac
where VAC > '0'
Order by UIC, PARA, LINE

Open in new window

0
 

Author Comment

by:kdeutsch
ID: 24422191
argh,
My development is in sql 2000 but prodcution is in sql 2005.
0
 
LVL 41

Expert Comment

by:ralmada
ID: 24422219
Well, you can use my last approach. It will work in both SQL 2000 and 2005.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question