[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 625
  • Last Modified:

what are virtual center log files.ldf

What are ldf files?  Can these files be moved to anther location or do they need to stay resident in  the Program Files\Microsoft SQL Server\MSSQL\Data directory.
0
wilsonhinds
Asked:
wilsonhinds
  • 2
2 Solutions
 
Sham HaqueSenior SAP CRM ConsultantCommented:
ldf files are the lifeblood of your database -
Transaction Logs

they can be moved though:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1492204&SiteID=17
0
 
Sham HaqueSenior SAP CRM ConsultantCommented:
example from BOL for copy/move a database:

BACKUP DATABASE Northwind
   TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
   FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
   FROM DISK = 'c:\Northwind.bak'
   WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
   MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now