Database log file changed name
-
SQL Server 2008 log file named changed
--------------------------------------------------------------------------------
Hi all,
Some how the log file name on one of my databases changed from dbname_log.ldf to dbname_1.LDF Can anyone explain why this happened? Just learning so need to know how to change it back to dbname_log.ldf. Can I just drop the database, rename the file,and then Attach the database with the renamed log file? Or is there something else I will need to do?
Bill
-
The _1 is typically default. Just curious... Why is it important for you to rename it?
Jared
CE - Microsoft -
When I try to execute the following with a _1 instead of _log it would not execute. So if I want to change it to _log, what do I need to do so I do not screw anything up?
-
When you try to execute what?
The physical name of a log file is irrelevant, it can be anything you like.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
What are you executing? What is the exact error you are getting?
Jared
CE - Microsoft -
think your getting confused with the log file name and the physical log file name
-
wmlbill (4/26/2012)
SQL Server 2008 log file named changed--------------------------------------------------------------------------------
Hi all,
Some how the log file name on one of my databases changed from dbname_log.ldf to dbname_1.LDF Can anyone explain why this happened? Just learning so need to know how to change it back to dbname_log.ldf. Can I just drop the database, rename the file,and then Attach the database with the renamed log file? Or is there something else I will need to do?
Bill
sounds like the database has been restored.
If you realllllllllllly want to change the name do the following;
change the file name and path using the following;ALTER DATABASE [yourdb] MODIFY FILE(name=logical name, filename=N'drive:\path\dbname_log.ldf')
You can get the logical name and current file location from sys.master_files take the database offline usingALTER DATABASE [yourdb] SET OFFLINE rename the physical OS file from dbname_1.LDF to dbname_log.ldf bring the database back online using;ALTER DATABASE [yourdb] SET ONLINE-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply