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 |
|
DBASlut
Yak Posting Veteran
71 Posts |
 Posted - 2006-03-21 : 17:05:01
|
| I've got 2 databases, prod and prod_qa. Whoever setup these databases are using the same Filenames for both. I have verified this by right clicking on each DB and looking at the properties. The location says a different filename, ie. there is a prod_data.mdf and prod_qa_data.mdf BUT in the File Name, both DB's are using prod_data and prod_log?I didn't think this was possible. How can I correct this so prod is using prod_data and Prod_log, AND prod_qa is using prod_qa_data and prod_qa_log. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-21 : 17:06:35
|
| It's the physical file name that matters, not the logical. The physical file names must be unique. Prod_Data and Prod_Log are the logical names. If you want to change them though, you can use ALTER DATABASE.Tara Kizeraka tduggan |
 |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-03-21 : 17:08:07
|
| thanks Tara.. |
|
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-03-21 : 17:13:26
|
| Tara, can it be done while the DB is in stand by mode? I want to change the logical name on the standby. If I restore/apply DIFFS will it change back to the logical name? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-21 : 17:16:46
|
| Standby mode means the database is in read-only mode, so no you can not make the change. But you really don't need to correct this as it isn't a problem.Tara Kizeraka tduggan |
|
|
|
|
|
|
Restoring Diff problems..