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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-02-20 : 11:32:09
|
| How can i change the file name ?I have restored AppDb to playApp ( when i resored it i've changed the file location to playapp.mdf and playapp_log.ldf)..Even though playapp has palyapp.mdf and playapp_log.ldf, the file name is still appdb and appdb_log..how can i change the file name to playapp and playapp_log?Having the same file name will not mess up the databases right? since they have different physical file location? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-20 : 12:43:40
|
Having two databases with the files logically named the same thing is not bad. You can change the logical name of the files with the alter database command. Something like this:alter database playapp modify file (name = 'AppDB', newname = 'PlayAppDB') |
 |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2007-02-20 : 12:57:59
|
| Thank you |
|
|
|
|
|
|
changing file name o