Viewing 15 posts - 31 through 45 (of 98 total)
For completeness sake:
In the long term (apart from the current situation with the long delete transaction), the log size will be maintained reasonably small by regular FULL backups (if the...
January 24, 2010 at 10:11 pm
GilaMonster (2/20/2008)
...there is no 64 bit solution to this problem.
That is correct. There is a 32-bit DTS Legacy solution though.
If you have SQL Server 2005, you can rewrite all...
January 20, 2010 at 8:04 pm
GilaMonster (12/21/2009)
Ivanna Noh (12/21/2009)
Gail - when i query sys.databases the value in the log_reuse_wait_desc column is 'LOG_BACKUP' - is that a result of mirroring?
Nope. It means exactly what it says....
December 21, 2009 at 3:20 pm
Ivanna Noh (12/20/2009)
thanks for the info Ol'SureHand - I will try adding a couple of additional log backups ... 🙂
Right you are ... but you may wish to introduce a...
December 20, 2009 at 8:13 pm
As long as you remember it is best to avoid shrinks as per Gail's admonitions and Kimberly Trip's recent article on transaction log fragmentation (sqlservercentral.com/blogs/dba_tipster/archive/2009/12/17/transaction-log-fragmentation.aspx)
[/url]
According to MS, you should be...
December 20, 2009 at 6:03 pm
Excellent trick question.
String comparison for both char & varchar ignores trailing spaces - even when ANSI_PADDING is ON.
December 6, 2009 at 4:10 pm
Well, there was a timeout each time I clicked "Post".
So I did not realise the message was being posted regardless ... sorry 'bout that! And there is no "delete...
November 5, 2009 at 7:37 pm
Also with respect, I was not criticising the SQL command but, rather, pointing to the question having more than one correct answer.
It is debatable if moving your database files (including...
November 5, 2009 at 7:24 am
Sorry, did not even notice the "RETURN" in the CATCH block.
The eye did not see what the mind did not expect...
The solution with the "executesql" full documentation to capture the...
November 5, 2009 at 6:54 am
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the...
November 4, 2009 at 11:00 pm
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the...
November 4, 2009 at 10:43 pm
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the...
November 4, 2009 at 10:30 pm
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the...
November 4, 2009 at 10:28 pm
IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).
That is because the BACKUP command comes AFTER the...
November 4, 2009 at 10:26 pm
Sorry guys, the answer is only partially correct.
Backup may happen happily IF you've got the backup folder in the C: drive.
Which I haven't as I move the entire structure to...
November 4, 2009 at 9:34 pm
Viewing 15 posts - 31 through 45 (of 98 total)