Restore Redgate Transaction logs files via SQL

The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.

Backup to the Cloud: The Silver Lining

Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.

Transaction Log Stairway Series available as a book

Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.

SQL Server Central Webinar Series #23: Safeguard your data offsite with SQL Backup Pro

You may already have a great backup and recovery plan. However, if something were to happen to your databases and you needed to restore from your backups, you’d want to be in control, with the ability to access a copy of those backups quickly, restoring them with minimal downtime and minimal fuss.

In this session Grant Fritchey, SQL Server MVP, will discuss the key reasons why you need to have offsite backups, and the advantages of hosted storage. He’ll address some of the fears surrounding cloud backups, and show how offsite backup is made quick and easy with the new ‘backup to hosted storage’ features in SQL Backup Pro 7.3.

Red Gate releases SQL Backup Pro 7

Red Gate Software has released SQL Backup Pro 7 with pioneering new features focused on SQL Server backup verification. SQL Backup Pro 7’s step-by-step scheduling wizards aim to simplify the process of restoring and verifying backups.

SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software.
This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore

RE: SQLXMLBulkLoad C# Issue on Insert :: URGENT HELP!

Yep,  that's what i got too.  The XML schema created from the ado.net dataset is not compatable with what SQLXMLBulkLoad expects.  Hard to believe that two things from microsoft would not be compatable.  A couple of things need to be yanked from the dataset schema to make it compatable.  (there was an example on some […]

RE: Strange problem with SQL Server 2000

Thanks for your reply I did find that autoclose was checked and made sure it was unchecked after this problem occured. Just have to see if that fixes it.

DTS & OWNER PASSWORD

I have a situation where a Developer created a DTS, put an owner password and an user password  & Finally forgot both. Developer requested me, if I could retrieve / reset the password. Even after spending a lot of time with BOL / Internet on the same topic, I could not solve this problem. Is […]