We have the following message returned from a scheduled task:
Executed as user: NMR1\sqltask. Cannot shrink log file 2 (DB_Log) because requested size (5120000KB) is larger than the start of the last logical log file. [SQLSTATE 01000] (Message 9007) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528). The step succeeded.
The step is part of a maintenance task that includes backup DB, log log shrink and index maintenance. The DB is in replication. How can I shrink the log.
Any help would be appreciated.