Technical Article

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: )

330 reads

Blogs

Why You Need Presentation Skills

By

And no, the answer is not because you want to be a Microsoft MVP....

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Read the latest Blogs

Forums

Pay close attention to little details

By johnjonston

It is crucial for Wikipedia contributors to decide what they will cover in their...

Easy Guide on How to Fix QuickBooks Error 15271

By rimssen

Error code 15271in QuickBooks is common error of the 15x series. A QuickBooks Error...

Suhagra 100 | Online Treatment For Men

By buymygenerix

Now all men can solve the problem of erectile failure at the time of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers