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...

Most of the content is copyrighted so you will have to purchase the resources you require from places such as Amazon.

There is no official MS Press book for 70-450, but...

You probably already know this but, as you have done select * in the query, it needs to return all the other columns along with the postal code. To...

there is no query, use SSMS, connect to server, expand database, expand tables, right click table, hover over script table as, click new query window

What is your RTO, RPO, once you know that information you can then decide on the best HA/DR method to take.