Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Changing File In SQL 2005

Posted on 2009-05-17
4
Medium Priority
?
183 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
3 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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

580 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