• That only works if the database was cleanly shut down - i.e. the transaction log doesn't have any transactions that need to be rolled back. In this case the database was not cleanly shutdown so your advice won't work.

    Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005