• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 630
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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