Solved

Changing File In SQL 2005

Posted on 2009-05-17
4
172 Views
Last Modified: 2012-05-07
I have a database with mulitple files and one an .ldf file has a file type of "data". Since it's this type of file type I can't shink the log file due to it being in use. Can I change the file type back to "log" with no issues?
0
Comment
Question by:Robert Pollick
4 Comments
 
LVL 9

Accepted Solution

by:
cdaly33 earned 500 total points
ID: 24407918
Are you saying that you have an ldf that is listed in MS SQL Management Studio as a Rows Data file type?  You can't change a data file to a log file.
0
 

Author Closing Comment

by:Robert Pollick
ID: 31582434
Thanks... I finally found it in the Help area.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24410205
the file names do not matter. you can name your data files and log files with any name/extension you wish, although it's not really meaningful to name a data file .ldf.

and as cdaly indicates: you cannot change a data file to a log file or vice-versa.

I do not remember to have seen a "file in use" error when shrinking a data or a log file ...
can you clarify how do tried to isse the shrink file?
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now