2010-02-08 (first published: 2010-01-13)
4,151 reads
2010-02-08 (first published: 2010-01-13)
4,151 reads
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
In order to create a unified and useful design, selecting the finest washbasin faucets...
Hi everyone I have a query that is taking a real long time. It...
Comments posted to this topic are about the item The New Log File
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers