That's covered in the link in my previous post.

John

I've a feeling you need to restore the resource database on the development server as well. Make sure you make a copy of the existing resource database before you...

In your WHERE clause, you're comparing the values in the date column to the value returned by the subquery. If that subquery returns more than one value, you'll get...

You either need an extra job step in the remote jobs so that they tell you when you've finished, or you need to poll msdb on the remote servers to...

You need to change it in the WHERE clause, not in the subquery.

John

If, as it seems, you're trying to fill the gaps in a sequence, create a numbers table[/url], left join it to your table, and set the value of B in...

How big is the largest table in each database? Is it possible that a query is coming along every now and then that does a table/clustered index scan against...

Are you restoring databases on the server, or rebuilding indexes?

John

OK, even if you've tested your DR plan and you have proved that you can recover to fulfil the required RPO and RTO (recovery time objective and recovery point objective),...

What is the exact wording of your business requirement? Taking transaction log backups at the same frequency as full backups is useless and you may as well just put...

First, don't use the append existing option, or you'll end up with a single file with dozens of backups in it.

Second, have separate maintenance plans for full and log backups,...

Well, you say they're unused and unneeded, so I'd say that dropping them would be the kindest thing. Unless they're clustered indexes, that is, but then they wouldn't be...

Just use DROP INDEX. Since you're dropping them, there's nothing to rebuild.

John

Yes, it's independent. You're probably best off fixing on SQL Server storage or file storage and sticking with it, so that you don't get too confused and have lots...

SELECT

SCHOOLID

,MAX(STATUS) STATUS

FROM #TEMP

GROUP BY SCHOOLID

ORDER BY SCHOOLID

John