is there a 2005 version of that tool? A quick search seems to suggest not and I would have thought the community would be crying out for one.

you need to install it separately

]http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en

thats the 2008 advisor for upgrading to 2008 from 2005 or 2000

which kind of defeats the purpose of logshipping..................you might want to restore from primary and start again 🙂

what does this do? the TUf file hold info on transactions that were not committed at the time of the tran log backup and may therefore need rolling back or...

Call me old fashioned but as its just a database backup why not do it as a SQLAgent job? They have configurable retry options

Use perfmon (system monitor), counter SQL server Buffer Manager:buffer cache hit ratio

agreed, unless I have hit a problem that requires the CU I don't apply them. Precisely because MS advise not to as CU's are not as rigourously tested as SP's.

congrats, grant.

thank you very much for all your input cmille, its good to know what can be achieved and pitfalls\advantages. I will definitely be insisting on replicating my system databases, and...

copied from this site at some time or other - cannot remember who's it was

/* Generate statements to create server permissions for SQL logins, Windows Logins, and Groups */

SET...

you are probably causing them to be blocked out and there queries are timing out. Run sp_who2 whilst you are running your query to determine this, a value in the...

there is an instance of _total for the counter, but not at all sure what that is actually counting. :unsure:

I would feed the results of dbcc sqlperf(logspace) into a table,...

..er, previous post of mine should have read dbcc loginfo(yourdbname), edited it

In DR scenario my AD administrators will update the DNS entry to point to the DR IP instead of the primary server IP. So in effect, I am renaming the...

what does the command dbcc loginfo(yourdbname) return?

If the status field of the last row (and therefore that last virtual log) has a value of 2 it has active transactions in...