Redmond Magazine

Restoring a Database to an Older Version of SQL Server

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...
Network World

Selecting the Appropriate Recovery Model for a Database in SQL Server 2005

In addition, there isn’t a need for point-in-time or up-to-the-minute restores.For more information on recovery models review chapter 3, “Administering SQL Server 2005 Database Engine” on my SQL ...
Ars Technica

MSSQL2000 restore from specific transaction log onto a different server

I'm trying to recover an earlier version of a database from a tape. I've got the bak file and all of the TRNs in a folder on a different server (wanted to restore it to our testlab sql server). From ...
ITWire

iTWire - Sequoia Voting System database laid bare but no secrets found

The file is a valid SQL Server backup and I was able to restore it with ease and without problem on my laptop. Those with access to SQL Server 2005 or 2008 can easily repeat my steps. First, download ...