Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Changing File In SQL 2005

Posted on 2009-05-17
4
Medium Priority
?
181 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 2000 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 143

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

885 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