Restore Database from MDF file without LDF

Hai raino,I saw ur query posted in SQLServerCentral.It was very useful.But if try to run the querydbcc traceon(3604)dbcc rebuild_log ('Training','Training_Log')Its showing the error=================Error================DBCC execution completed. If DBCC printed error messages, contact your system administrator.Server: Msg 5105, Level 16, State 2, Line 2Device activation error. The physical file name 'Training_LOG' may be incorrect.DBCC execution completed. If […]

2005-06-08 (first published: )

328 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SBCglobal email not working

By serviceemail

People having trouble while they login in SBCglobal email not working. And if you...

SBCglobal email not working

By serviceemail

People having trouble while they login in SBCGlobal email. And if you are one...

Capture login information

By mcfarlandparkway

I want to Capture Login information in table or view. who connected to database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers