Hai

Toutes les réponses

• lundi 18 février 2013 06:24

   

   
  

  0

  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
  •  
  • Réponse
  • Citation

   
• lundi 18 février 2013 14:40

   

   
  

  0

  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
  •  
  • Réponse
  • Citation