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 […]

You rated this post out of 5. Change rating

2005-06-08 (first published: )

334 reads

Blogs

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs

Forums

Scaling Up Monitoring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Scaling Up Monitoring

Database Sequence Objects with dbatools

By Mikey Bronowski

Comments posted to this topic are about the item Database Sequence Objects with dbatools

Why a monitoring tool is an essential tool for growing server estates

By Site Owners

Comments posted to this topic are about the item Why a monitoring tool is...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers