SQL Server : Point – in – Time Recovery

How to perform point-in-time-recovery? Continue reading

Advertisements

Quick Way to Create Single Table Backup

There are several ways to create backup for a single table in SQL Server database. In SQL Server 2008, now you can create insert statements for selected tables. Beside this Export wizard is commonly used to create a flat file backup for a single table. Both methods are reliable but still time consuming. And when I searched for quickest method to take backup of a single table I found following code by SQL Expert Fred. Continue reading

SQL Server Backup and Restore

Back to Basics with SQL LiteSpeed

by Amit Vaid

One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. Continue reading