Viewing 15 posts - 3,676 through 3,690 (of 4,745 total)
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.
May 7, 2009 at 4:34 pm
you need to install it separately
thats the 2008 advisor for upgrading to 2008 from 2005 or 2000
May 7, 2009 at 4:24 pm
which kind of defeats the purpose of logshipping..................you might want to restore from primary and start again 🙂
May 7, 2009 at 3:52 am
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...
May 7, 2009 at 3:40 am
Call me old fashioned but as its just a database backup why not do it as a SQLAgent job? They have configurable retry options
May 6, 2009 at 3:59 pm
Use perfmon (system monitor), counter SQL server Buffer Manager:buffer cache hit ratio
May 6, 2009 at 3:40 pm
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.
May 6, 2009 at 3:36 pm
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...
May 6, 2009 at 5:02 am
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...
May 5, 2009 at 3:38 pm
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...
May 5, 2009 at 3:25 pm
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,...
May 5, 2009 at 10:49 am
..er, previous post of mine should have read dbcc loginfo(yourdbname), edited it
May 5, 2009 at 10:08 am
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...
May 5, 2009 at 9:48 am
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...
May 5, 2009 at 9:28 am
Viewing 15 posts - 3,676 through 3,690 (of 4,745 total)