We use a 3rd party program that displays this data but it doesn't provide enough for me to do some good research.

I ran select * from sys.dm_xe_sessions and see a...

Log is good, it contains no missing data that I can see and goes back several days.

Status = 1

Yes, the logfile is still being used, it just truncates when a database event occurs. What are your autogrowth settings? If they are 1 MB, then by the time an...

What are the autogrowth settings? Like, 10 MB, 10%, etc?

I did DBCC Traceon command with -1

I could probably condense this down but I had to do it real quick. I believe this will work for you and you can change it just to return ID's.

WITH...

This is something I haven't toyed with yet and looks very helpful. Thanks so much!

Can you provide the exact and full message?

You have to create a column list, not sure about the name of the fields you're inserting to but it should look like this,

SET IDENTITY_INSERT SecuritySettings ON

GO

INSERT INTO SecuritySettings (

[SecuritySettingsId]

,...

You need to explicitly change the names through a script,

ALTER DATABASE [DATABASE NAME] MODIFY FILE (

NAME = [Old Logical Name]

, NEWNAME = [New Logical Name]

)

GO

Just to make sure I understand. You're trying to restore a backup to a DB on a different server? I'm assuming this is the same DB and is used for...

I'm not sure how you're application architecture is arranged. The issue that you could see is if there's a duplicate GUID in both locations. If your .net app only generates...

Shrink and Rebuild works great for one time operations but I'm curious as to what happened originally. Was there a one time operation that inserted a massive amount of a...

Here's a script that's been floating around for a very long time that will help you out,

--CREATE THE STORED PROCS TO GENERATE THE LOGINS--

USE master

GO

IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL

...