Home Forums SQL Server 2005 Backups i have mdf and ldf files how to restore these 2 files in sqlserver 2000 RE: i have mdf and ldf files how to restore these 2 files in sqlserver 2000

  • ps (12/13/2008)


    You can also create a dummy database with the same name as your original database, shut down sql server service and overwrite your data files with original files. Restart sql server service, It'd recover the data you had in the original database.

    This is more of a cowboy way (e.g. not a supported way, but it works). In order for it to work you also need to create the dummy database's files with the same name as the LDF, MDF and NDF files that you have.

    Personally I used it only once few years ago when I needed to attach a database that was detached while it was in suspect mode. Since the database could not be attached, I used your approach. In all other cases, when I can attach the database in the normal way, I don't see any reason to use this method.

    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/