• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Changing File In SQL 2005

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?
Robert Pollick
Robert Pollick
1 Solution
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.
Robert PollickConfiguration ManagerAuthor Commented:
Thanks... I finally found it in the Help area.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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?
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 expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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