yes basically you need a subquery.

the query I use for this is

select a.name, b.backup_finish_date

from master..sysdatabases a left join msdb..backupset b on a.name = b.database_name

where b.backup_finish_date = (select min(backup_finish_date)...

that post was deserving of being the 1,000,000th .

WayneS (10/4/2010)

---

Lynn Pettis (10/4/2010)

---

As alluded to above in one of the posts, BEFORE dropping the database be SURE you take a FULL BACKUP of the database. This way you...

Michael Valentine Jones (10/5/2010)

---

You could create a database snapshot for users to report from, and continue to apply logs to the database.

Users would only be disconnected when you recreate the...

what post just to hurry the count along? Who'd bother to do that?

This is an area where SQL is lacking. Logshiping cannot support this requirement.

If you want it that up to date and 'off server' then replication is about it.

I resemble that remark.........

well we tried a run of our ETL process with tempdb on SSD and elapsed times were comparable to the standard disks, i.e. no real improvement.

What this shows (to me...

only way with log shipping is store the logs up and restore them out of hours. Easily done by adjusting the restore job schedule.

Users would have to accept data that...

no links but we run diskkeeper with SQL up and running, no problems.

£50 says it's lack of space! Error 112 in the error log

apply to test servers first and backup system databases before and after.

Personally I stop SQL beforehand and take flat file copies of the system databases as well (including resource database),...

yes those are the correct instructions to bring the mirror on-line. don't forget you may also have to change the database owner and re-synch userids.

You also have the option of...

🙂 ah such an optimist! I do not think so but if it is important...

er........I doubt it. What exactly were you looking for?