• You can rename the originals database’s files. Then create a new database with the exact same name and files (name and location) as the original database. Stop the service delete the new database’s files and rename the original database’s files to their original names. Start the service again, and you’ll have the original database in its suspect mode. One very important noticed – I’ve done it once with SQL Server 2000, but I never tried it with SQL Server 2005.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/