Thanks so much for the benefit of your experiences with table variables as opposed to temporary tables. It's just such insights that I find very helpful.

Thanks.

Thanks once more for pointing out the best uses for, and against using @ type table variables.

I do seem to recall reading somewhere that such table variables should be only...

Thanks so much for the excellent and comprehensive answers to my question 🙂

I've never used MERGE, but it appears as if it's something to look into.

Looks as if your examples provide the answers I need.

Thanks 🙂

Hmmmm ... of course, now that I've dropped and restored the DB I can see that for some reason my log file has been renamed.

Not sure why this should happen.

Had to drop the DB, but the restore then worked fine.

Thanks. 🙂

*** it happens, I already use CHECKSUM. I also run a DBCC CHECKDB on the database before being backed up ensuring that should that fail that the backup is not...

Ninja's_RGR'us (12/12/2012)

---

There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.

Now you know you're good.

Once that's done you can't move the files because they could get corrupted in...

Indeed, plenty of food for thought there.

Thanks once again for all your kind help.

Ohhh errr 🙂

Thanks for that. I'd hoped that SQL server had some simple DMV that would provide this information, but no matter.

So, no indexes, no way of finding the time...

Thanks for tthat.

GilaMonster (11/28/2012)

---

raotor (11/28/2012)

---

My full backups are done to the same file (i use NOINIT option on BACKUP), so the same physical backup file contains both full backups as far as...

Ahhh, well at least it's the GUI and not me for a change 🙂

Thanks.

GilaMonster (11/28/2012)

---

raotor (11/28/2012)

---

Today I performed a second full database backup after thinking I wouldn't destroy the chain and now I cannot restore the database to a point in time before...

There's no error as such.

When I right-click on the database, click Tasks, click Restore and then select Database the list of available...