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 |
|
ssengu
Starting Member
1 Post |
 Posted - 2011-06-29 : 17:00:51
|
| Hi,Mirroring concept principal Db log file more space on occupied drive what we do Can we shrink or what is the option ? send me the tips and explain thanks advance.and hw to online Mirrred DbDBA TEM |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-29 : 17:06:38
|
quote:
Mirroring concept principal Db log file more space on occupied drive what we do Can we shrink or what is the option ?
Don't shrink the log file. Take regular transaction log backups (every hour, every 15 minutes, whatever interval is appropriate) and keep the log file large enough to accommodate significant transactions without causing auto growth.quote:
and hw to online Mirrred Db
You cannot access a mirrored database except to perform a mirror failover. This is documented in Books Online. Once you fail over, the mirror becomes the principal, and the former principal goes into a mirrored state. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
Mirroring issue ....