If I'm seeing the 'Logical name' ATCB come up instead of CPCE (the expected logical name) do I have something set incorrectly on my backup process and how can this...

I ran this command with no errors:

restore filelistonly from disk = 'C:\DATABASES\ACS_DB_backup_201709010016.bak'

Which gave me a physical path of D:\Databases\Data\ACS_DB_Data.MDF and D:\Databases\Data\ACS_DB_Log.LDF

But this fails:

RESTORE DATABASE...

I'm reviewing the drive structure. I do get an error that WITH MOVE is not a restore option.

It isn't pretty but this is working fine... hopefully this will help someone:
USE [BCC_DB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[UserLogViewByDB_withStates]

Note that I had the when 'AR' then 6 on those when I meant when 6 then 'AR' but hope you get the picture.

One way I might be able to do this avoiding a join would be to place some type of case block in this:
[stateID] = CASE [State...