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

324 reads

Blogs

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Read the latest Blogs

Forums

Building Your Brand

By Grant Fritchey

Comments posted to this topic are about the item Building Your Brand

A Little Paranoia is Good

By Grant Fritchey

Comments posted to this topic are about the item A Little Paranoia is Good

Auto Rounding

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Auto Rounding

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers