Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

sql 2005 db mirroring

Hi,
In sql 2005 mirroring, can I truncate the trans log? or which one that I can truncate principal or mirror?
0
motioneye
Asked:
motioneye
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should NOT truncate the log in mirroring.
you can only run regular transaction log backups (which actually do the same in regards to the transaction log size)
0
 
motioneyeAuthor Commented:
so is that means no any other way to truncate the trans log??? and will this backup log dbname with truncate_only will not work with mirroring???
0
 
imran_fastCommented:
Agree with angelIII
Mirroring is dependent on the trasaction log so dont truncate them take regular backups.
0
 
motioneyeAuthor Commented:
ok, if the trans log unallocated space getting bigger will backup log dbname with truncate_only  work if the shrinking command unable to shrink the unallocated space? is there any problem with mirroring db?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>will backup log dbname with truncate_only work...
no. simply doing the regular backup (without the truncate_only) will keep the file size "constant", with reusing the space inside the file.
note however that the longer the distance between the backups, the bigger the file needs to be.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now