Viewing 8 posts - 31 through 38 (of 38 total)
I hate to nitpick but I don't believe that many are using SSD's for their logfiles. The main performance advantage of an SSD is IOPS. 15k RPM drives aren't much...
August 16, 2011 at 7:25 am
From msdn:
If a log backup becomes missing or damaged, start a new log chain by creating a full or differential database backup and then backing up the transaction log...
August 1, 2011 at 1:59 pm
Yes, there are a number of extra steps needed to ensure a backup works 100% of the time. It's unfortunate that Microsoft hasn't included a "virtual restore" functionality to SQL...
July 28, 2011 at 8:20 am
You're right, Ray. SQL Backup Pro does not include those features. I meant to recommend Redgate's SQL Backup and Restore Bundle, which does include that functionality.
That said, comparing the...
July 26, 2011 at 10:32 am
That option performs a "RESTORE VERIFYONLY" after a backup has been taken, and returns the result.
You can read more about RESTORE VERIFYONLY here: http://msdn.microsoft.com/en-us/library/ms188902%28v=SQL.90%29.aspx
While this does verify that...
July 18, 2011 at 3:19 pm
It is a good catch-all, but the way I read your post made it sound as though it was the only correct option, or a best-practice at least. I just...
July 15, 2011 at 2:31 pm
RAID 1 on a good RAID controller most certainly will affect read performance. It will multiply theoretical throughput and MaxIOPS by n times over the performance of a single disk....
July 15, 2011 at 12:59 pm
Gila, it was my understanding that SQL uses the timestamp (rowversion) column for incremental population of Full Text Indexes. It's not purely for Front-End app use.
July 13, 2011 at 1:48 pm
Viewing 8 posts - 31 through 38 (of 38 total)