Stack Overflow
Stack Overflow

Questions tagged [ldf]

A transaction log file (also database log or binary log) is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. Physically, a log is a file of updates done to the database, stored in stable storage. (from wikipedia)

48 questions
0
votes
3 answers

SQL Server, Restore a .BKP file into an MDF file but not LDF (no space for it)

I'm in an issue where I don't have enough space to accomodate my MDF and LDF files from a LiteSpeed backup we had done. I've come up with the following sproc: exec master.dbo.xp_restore_database @database = 'OSiteDB', @filename =…
halivingston
0
votes
1 answer

SQL Server database reattachment error (not a permission issue)

I'm stuck on trying to figure out this error, with absolutely no luck whatsoever. I've already went through the SO, found some bits and pieces to help me figure this out. I need to create a scheduled job that will copy and rename a database on 1st…
user9149696
0
votes
1 answer

Why is my LDF so large?

I have a Microsoft SQL Database with an LDF of 500MB. Usually, this is less than 1mb. Recovery Model is set to simple. This is SQL Server 2014 Standard x64. Any idea why the LDF would be 500mb if the recovery model is simple? I have tried shrinking…
Devon Quick
  • 348
  • 1
  • 17
0
votes
1 answer

Importing views from microsoft sql server 2003 fail

I'm trying to migrate from microsoft sql server 2003 to sql server 2016. Importing the data went well, using Microsoft SQL Management Studion 2016, but the views were not imported. And here is my request, how can I import the views? At this point I…
Gaetan L'Hoest
  • 60
  • 9
0
votes
1 answer

Restore database from bak and ldf files

I just created database from an old bak file and need to recover database to latest version but I don't have recent backups or mdf file but only ldf file. How can I recover DB from from only ldf file?
tret
  • 9
  • 1
0
votes
2 answers

LDF FILE DELETION

Is there a way by which I can delete periodically the LDF file generated as it takes upto 100 gb of my space and I want to free that space. Is there a way a procedure can be written that periodically deletes this LDF file?
rahul
  • 27
  • 5
0
votes
0 answers

Recover .ldf file in sql server

i deleted manually all the .ldf file in the sql server 2008 of my local [path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA]. I am also stopped the SQL server (MSSQLServer) and then deleted. Now while i try to restart, it…
salaiviswa
  • 43
  • 8
0
votes
0 answers

how to recovery the records from the ldf file?

Yesterday,my database file is broken,and i can't connect it.I just have the backup file before. Now,the database files can not be attached. 标题: Microsoft SQL Server Management Studio 附加数据库 对于 服务器“BAUER”失败。 (Microsoft.SqlServer.Smo) 有关帮助信息，请单击:…
WQS
  • 21
  • 3
0
votes
1 answer

Should I put my .mdf and .ldf files from my code into Visual Studio Team Services repository

If I create a .sqlproj file that contains all my sql objects, why would I need to put my mdf, ldf files into VS Team Services source repository? Doesn't the .mdf contain all the data? If that is true then I probably wouldn't want to store all the…
chuckd
  • 13,460
  • 29
  • 152
  • 331
0
votes
1 answer

How to move database and attach it to SQL Server 2008

I am not able to attach a database to a SQL Server 2008 on different machine. I moved the .mdf and .ldf files after detaching the database from one computer to another. When I try to attach the database on new machine the database does not show up…
user2149838
  • 49
  • 1
  • 1
  • 8
0
votes
1 answer

Risk of Delete the LDF file in sql server 2008 r2

I am a developer and my manager want me to delete all the LOG file (LDF) for all database in sql server. please tell me what are the risks if i delete the Log file of a database thanks.
Ibra
  • 192
  • 11
0
votes
1 answer

SQL Server 2012 simple recovery mode - recovery options after crash

I have two questions about DB on SQL Server 2012 with recovery mode set to Simple (and DB itself holding mainly two huge tables with billions rows of data): in case of crash (or power failure etc.) can we recover something from .mdf and .ldf files…
Jan
  • 1,905
  • 17
  • 41
0
votes
2 answers

LDF file continues to grow very large during transaction phase - SQL Server 2005

We have a 6 step where we copy tables from one database to another. Each step is executing a stored procedure. Remove tables from destination database Create tables in destination database Shrink database log before copy Copy tables from source to…
that_developer
  • 319
  • 2
  • 9
0
votes
1 answer

log backup file disk size issue in MSSQL 2005

I have a problem about managing ldf file's size. Db's recovery mode is Full. So ldf file is reached at 360 gb. I want to decrease it by performing log backup. But currently disk does not have 360 gb free space. So backup file is growing…
TayfunSezer
  • 89
  • 2
  • 11
0
votes
3 answers

VS2010 Code First MVC3 SQL default Logfile.ldf name format ignored, creates second logfile_log.ldf file

Using VS2010 code first and SQL Server 2008r2 with an MVC3 webapp, the SetInitializer creates a db as expected when missing or on model changes. The db created has the filename format database.mdf and the **logfile database.ldf (can this default…
Andrew Harvey
  • 1
  • 2
1 2
3
4