August 22, 2011 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
Replication,
Restore DatabaseSo the other day I had to restore the SQL Server replication publisher. When I restored it I made sure to use the KEEP_REPLICATION option on the restore (also available in the SSMS UI) so replication should come back online. However when I restarted the log reader I the following error...
August 11, 2011 3:00 PM
Posted by: Denny Cherry
Blog,
SQL Server,
SQL Server Magazine,
Storage,
TroubleshootingI'm very please to tell you all about my new storage blog on sqlmag.com titled "Troubleshooting SQL Server Storage Problems". On this new blog (there's just the one post for now, but that...
August 8, 2011 2:00 PM
Posted by: Denny Cherry
Dev Connections,
EMC World,
SQL Excursions,
SQL PASS,
Tech EdThe 2011 conference season is starting to come to a close. There are only a few large conferences left such as VM World, SQL PASS, and Dev Connections. Many people are currently working with their bosses to get sent to these conferences.
However while going through these conversations here's...
August 1, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
StorageThis question came up on ServerFault a while back and a wanted to expand on the solution more. The basic problem that the person was having was that the iSCSI disks were taking a long time...
July 28, 2011 2:00 PM
Posted by: Denny Cherry
AlwaysOn,
DR,
SQL Server,
SQL Server 11,
StoragePeople often get HA (High Availability) and DR (Disaster Recovery) mixed up. There are a couple of reasons that this happens. First is the fact that there aren’t any clear guidelines which separate the two. There are standard terms which are used to help define HA and DR, but there’s...
July 7, 2011 2:00 PM
Posted by: Denny Cherry
Backup & recoveryI recently installed HyperBac on a clients SQL Server to reduce the amount of space needed to store their backups. Specifically we were looking to reduce the amount of space the log backups took, but I was curious to see how much space the full backups would be reduced by.
The full backups...
June 27, 2011 7:39 PM
Posted by: Denny Cherry
SQL Excursions,
SQL Server,
StorageAs SQL Excursions is getting closer, I wanted to talk a little about the sessions that I'll be presenting at the event which I'll be doing over this week. The sessions that I'll be presenting...
May 30, 2011 2:00 PM
Posted by: Denny Cherry
Restore Database,
SQL ServerWhen doing a database restore and you want to move the physical database files from one disk to another, or from one folder to another you need to know the logical file names. But if you can’t restore the database how do you get these logical file names? By using the RESTORE FILELISTONLY...
May 30, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
StorageI would probably make 2 RAID 10 RAID groups one for the data files, and one for the transaction log. Without knowing what percentage of data access will be read and what will be write I’m just guessing here. Depending on the load RAID 5 may work just fine for the data files.
Denny
