the log column of sysjobstepslog is nvarchar(max) so can hold up to 2gb of data, so should be more than enough when logging to the table.

there is no way to audit people adding people to groups as thats outside of SQL, what you could do is run xp_logininfo on the group at regular times and...

well you will need two variable then one for the lower value in the range and one for @FromDate

Something like @FromDate date, @ToDate date where @FromDate = 2012-05-01 or 2012-05-15...

Two things I can think of,

1 - have a secondary job which is fired from the completion of Job 1, which pulls the information from the sysjobstepslogs table and runs...

engelbert humperdinck

Fruit Salad

Your going to have to build in some code which does a check on @FromDate and change the value to the right one for the date range it is in,...

No you didnt set it up wrong, its just you said to constaintly backup to the same file so it keeps adding each TX Log backup to the same file...

actually after remembering, you need to use the INIT command as well, which will allow the media set to be overwritten so it will mess up your PIT Restores.

your best...

Personally I would ask the company you recieve the files from for a copy or details of the schema which they export from, so that you can get an exact...

Yes, and might take some time depending on how many logical files are within the physical file

Your confusing the TRN and LDF, they are NOT the same thing

TRN = Transaction Log BACKUP

LDF = Transaction Log

How big is the LDF file for the Production database? ...

Just need to add the convert to the end of the dataadd/difs

SELECT CONVERT(VARCHAR,DATEADD(dd,DATEDIFF(dd,0,DATEADD(MONTH,-13,GETDATE())),0),101)

.TRN usually means its a transaction log backup file, not the actual log file used in the database, this has the file extension .LDF.

If every log backup is running the...

such a broad topic, there are plenty of good articles buy doing a search in a search engine of your choice, but if you have something specific, please follow the...