Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sridharsridhar
Starting Member
21 Posts |
 Posted - 2013-07-22 : 09:38:20
|
| Hi we have installed SQL server 2008 and Restored previous Databases into new Databases. When we restored it to new database 2 Files created for every database 1 is mdf and 2nd one is ldf . for 2 database when we restored it did not stored in the mdf format it was saved in Database name . can we rename this file Thankssridhar |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-22 : 10:03:03
|
| The mdf and ldf extensions are extensions for primary data file and log file respectively by convention; they are not mandatory. So even if you did not rename your files there will be no issues. However, if you do want to rename them for consistency (which is a good idea), do what I suggested in your other question here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=186994You should follow that procedure exactly - don't simply rename the file without doing the other things. Also, test it in an environment before you do it for real. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-22 : 10:16:37
|
| you can rename it.Use RESTORE DATABASE WITH MOVE optionhttp://msdn.microsoft.com/en-us/library/ms190447(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SQL Datafile Rename and format change