Viewing 15 posts - 91 through 105 (of 994 total)
No, you're not guaranteed that you'll have data loss, but it's more likely. As long as you're doing frequent log backups, and you're able to do a tail-of-the-log backup, you...
June 25, 2012 at 6:08 am
You don't know which logs you can restore up to. If you want to guarantee zero data loss you can't rely on just backups - you need to have...
June 25, 2012 at 5:57 am
Glad you like the article.
Backup strategy is dictated by what restores you want to be able to do, what the data volume is, what storage space you have, and so...
June 25, 2012 at 5:40 am
The script should be titled 'check if backup file exists' as all doing a restore verifyonly does is make sure the file is there and a cursory look at the...
April 30, 2012 at 1:52 pm
Benign. See http://www.sqlskills.com/BLOGS/PAUL/post/Corruption-bug-that-people-are-hitting-Msg-8914-PFS-free-space.aspx
March 15, 2012 at 10:56 am
You've fallen into the classic trap of not filtering by allocation unit type - any LOB_DATA or ROW_OVERFLOW_DATA allocation units with fragmentation will trigger index rebuilds/reorganizes even if the IN_ROW_DATA...
October 21, 2011 at 5:01 am
You shouldn't have to stop any HA/DR product to run CHECKDB.
This looks like a bug in XOSoft that it doesn't cope with the NTFS alternate streams that CHECKDB uses by...
September 23, 2011 at 8:25 am
I can think of all kinds of things I'd like to make it say...
September 15, 2011 at 3:09 pm
The bytes that are 2 in your incorrect fields should be 1 or 0 - the sign. Create a table with numeric (2,0) and then insert 1 and -1 into...
September 15, 2011 at 2:49 pm
Can you post a dump style 3 DBCC PAGE output that renders correctly in notepad - then we can help you.
September 15, 2011 at 12:45 pm
Correct - the only way to know whether a transaction is wholely contained within a data backup is if the LSN of the commit log record is within the range...
September 7, 2011 at 9:07 pm
One correction on this - after switching from simple to full or bulk-logged, you can restart the log backup chain with a differential backup instead of a full backup, as...
September 7, 2011 at 7:52 am
sqlmashup (8/23/2011)
have not tested this but in case someone already knows the answer, wouldn't this miss items like data purity, filestream and others mentioned specifically in BOL?
Yes - it will...
August 23, 2011 at 5:33 pm
Hey Ian - one thing to check out with your script is what effect it has on the buffer pool. CHECKDB won't flush the buffer pool as all the pages...
August 23, 2011 at 9:37 am
Nice - but really only the equivalent of BACKUP DATABASE ... WITH CHECKSUM.
I would strongly advise not using this for the same reasons I strongly advise not using BACKUP DATABASE...
August 22, 2011 at 11:02 pm
Viewing 15 posts - 91 through 105 (of 994 total)