none
Hai

Réponses

  • Hi,

    you can use your last full backup and restore it may be with replace option to replace the log and data file.

    I hope this is helpful.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid

    MCSE Data Platform
    MCITP: SQL Server 2008 Administration/Development
    MCSA SQL Server 2012
    MCTS: SQL Server Administration/Development

    MyBlog

    • Marqué comme réponse rajkat85 mardi 26 février 2013 02:21
    lundi 18 février 2013 06:24
  • You can also attach a mdf file without a ldf file and SQL Server will re-create a new Log file.

    1. Shutdown instance

    2. Copy mdf file to new location

    3. start instance

    4. Attach database with copied mdf file with a new database name or on a different instance

    new file created.

    Thomas


    TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA

    • Proposé comme réponse TheSmilingDBA lundi 18 février 2013 14:40
    • Marqué comme réponse rajkat85 mardi 26 février 2013 02:21
    lundi 18 février 2013 14:40

Toutes les réponses

  • Hi,

    you can use your last full backup and restore it may be with replace option to replace the log and data file.

    I hope this is helpful.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid

    MCSE Data Platform
    MCITP: SQL Server 2008 Administration/Development
    MCSA SQL Server 2012
    MCTS: SQL Server Administration/Development

    MyBlog

    • Marqué comme réponse rajkat85 mardi 26 février 2013 02:21
    lundi 18 février 2013 06:24
  • You can also attach a mdf file without a ldf file and SQL Server will re-create a new Log file.

    1. Shutdown instance

    2. Copy mdf file to new location

    3. start instance

    4. Attach database with copied mdf file with a new database name or on a different instance

    new file created.

    Thomas


    TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA

    • Proposé comme réponse TheSmilingDBA lundi 18 février 2013 14:40
    • Marqué comme réponse rajkat85 mardi 26 février 2013 02:21
    lundi 18 février 2013 14:40