August 25, 2008 11:00 AM
Posted by: Denny Cherry
Backup & recovery,
KILL,
Log Shipping,
Recovery,
RESTORE LOG,
SQL Server 2005,
xp_delete_file,
xp_dirtreeSo you've been tasked with setting up a quick and dirty reporting server. The goal is to restore the log files from the production server to the reporting server nightly.
The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine. But...
August 21, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Code Camp,
In Person Events,
Service Broker,
SoCal Code Camp,
SQL Server 2005,
SQL Server 2008,
StorageI and many of the other presenters have begun entering our sessions for the next SoCal Code Camp on on October 25th and 26th...
August 20, 2008 10:58 PM
Posted by: Denny Cherry
Awareness Technologies,
In Person Events,
Laptop Cop,
Quest Software,
Service BrokerLast night was my talk with the NJ SQL User Group. I would jut like to thank them for the invite, I had a great time coming and speaking with them. It was a very interactive night, with a lot of questions.
August 14, 2008 11:00 AM
Posted by: Denny Cherry
In Person Events,
New Jersey SSUG,
Service Broker,
SQL Server 2005,
SQL Server 2008After months of waiting the time is finely here. I'll be speaking at the
August 13, 2008 10:37 PM
Posted by: Denny Cherry
Certifications,
Ed Tittle,
IT careersEd Tittel has written an excellent post on his blog (IT Career JumpStart) entitled
August 13, 2008 1:05 AM
Posted by: Denny Cherry
Capacity Manager,
Consolidation,
David Swanson,
Performance Problems,
Quest Software,
SoSSE,
SQL Server 2005,
SQL Server 2008Consolidated too many databases or too many instances onto a single server? Got users screaming for their own servers back?
Join myself and David Swanson from Quest Software (and frequent poster on
August 11, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Restore Database,
SQLThe restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command. The syntax of the RESTORE DATABASE...
August 7, 2008 11:00 AM
Posted by: Denny Cherry
KB 250367,
MS DTC,
MSCS,
RPC,
SQL,
Windows Server 2003Back in the Windows 2000 days, getting DTC to work was easy. It was setup by default to work. There wasn't a whole lot of configuration which needed to be done...
