My earlier script for quick restore of SQL db's for developer use needs an additional tweak for SQL Server 2005.

The RESTORE command has been enhanced with an additional safeguard: SS2005 will check if the "tail" of the transaction log has been backed up. This tail refers to transactions that have occurred after the last backup. The developer doesn't need the tail in this "quick restore" scenario, because all we want to do is overwrite the test db with the current data. Therefore all we have to do is add the WITH REPLACE option to our script, like this:

RESTORE DATABASE
par_pos
FROM
par_pos_1
WITH RECOVERY,
REPLACE,
MOVE
'QSDB_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\PAR_POS_Data.MDF'