Were the backups working, and just started failing ? Configuration change ?

What tells you they failed ?

• This reply was modified 4 years, 6 months ago by homebrew01.

I use the first 2 fingers on each hand, and also the ring finger on my left hand for the 'A' key and the <shift> key. I use my thumbs...

That might work if I can figure out how to get line breaks after each row.

Download the developer free version and start using it, in addition to the previous suggestions.

Hi Scott,

like I mentioned earlier, the WHERE clause is added afterwards in my application (so the user can choose to see archived corporations only, active corporations only or both)....

• This reply was modified 4 years, 6 months ago by homebrew01.

Edit...

• This reply was modified 4 years, 6 months ago by homebrew01.

Is this some kind of guessing game contest ?

I have never encountered that. Is it possible some step is running after the restore that changes the recovery model ?

I don't think your group by should include

s.OH,

o.SOQ,

" ...There's also nothing that will prevent the user from changing databases after they login and, they usually do have to.  Most people end up being taken to the "Default Database"...

• This reply was modified 4 years, 6 months ago by homebrew01.

How about

INSERT INTO DataMap.dbo.Audit_Logins
SELECT ORIGINAL_LOGIN(), GETDATE()
where db_name() = 'DataMap'

• This reply was modified 4 years, 6 months ago by homebrew01.

--Create a symmetric key, to be used for column encryption
CREATE SYMMETRIC KEY BeersKey
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE Beers;

'qwerty123' is more complex. I never encrypt my beer,...

• This reply was modified 4 years, 7 months ago by homebrew01.
• This reply was modified 4 years, 7 months ago by homebrew01.
• This reply was modified 4 years, 7 months ago by homebrew01.

Now that you're on paid SQL 2014, have you configured compression in your backups, since you mentioned storage is a consideration ?

Using a SQL Scheduled job to run backups has...

• This reply was modified 4 years, 7 months ago by homebrew01.

SQL Trace, or newer tool, Extended Events.

What happens when you try to attach the MDF ?

Could you create a new database with the original name, create a filetable for it, detach the new database, then attach...