Friday, March 23, 2012

log file size and mirroring

May I ask a question related issue? Is the participal database should be pause before shrinking?

Regards,

Melih

USE XXX
GO
CHECKPOINT
GO
BACKUP LOG [XXX] TO [XXX_TLOG] WITH NOFORMAT, INIT, NAME = N'XXX-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
DBCC SHRINKFILE(XXX_Log, 1)
GO
I think its not required to pause the mirroring session while shrinking
refer http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=377087
|||

Yess, Deepak,

You're right. It's not required to pause. It's working now, but after many try.

Thank you for suggestion.

Regards,

Melih

No comments:

Post a Comment