I am trying to shrink log file for a testing database.This database will be restored with production database periodically.When i tried to create backup of the log file
Processed 0 pages for database 'hcbeta', file 'HC_log' on file 6.
The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.
BACKUP LOG successfully processed 0 pages in 0.423 seconds (0.000 MB/sec).
I tried EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1
Resulted with error:Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication.
So tried to publish the database using EXEC sp_dboption 'hcbeta', 'Publish', 'true'
resulted error mesage:Msg 15242, Level 16, State 1, Procedure sp_dboption, Line 138
Database option 'Publish' is not unique.
and retrived duplicate_options as "merge Publish" ,"Publish"
Plesae help me in shrinking my database log file.
View Complete Post