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 |
|
matthew00
Starting Member
10 Posts |
 Posted - 2012-03-19 : 09:00:53
|
| I moved the TLog files to different location last week and here what I found out from experience.you can deattach and moved with the files and attach the file after ward. Pretty much you have to Alter the database, take offline then bring SQL back online. 1. My question is if "alter database", will that carry over to the Mirrored site?2. If it carried over to the mirrored site and the location of where I moved Tlogs to on the Principal doesn't exist on the mirrored site, what will happen when I recycle the Mirrored site?3. With the fact I already moved the logs on the principal site, what can I do for the mirrored site if the "alter statement" got carried over to the mirrored site.Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
alishaali
Starting Member
8 Posts |
Posted - 2012-03-26 : 10:51:04
|
| "Alter database " will only change the physical state of primary server . that will not logged.. and more over once u use "alter database" when that particular database is configured for mirroring ,that action will not take place unless the mirroring is dropped... |
 |
|
|
|
|
|
Move TLogs on SQL that had Mirroring