moin,
wir haben eine DB mit ca. 200MB aber die LOG hat ca. 1,3GB.
wie kann ich sicherstellen, dass alles eingerollt wurde? Backup wurde durchgeführt. Sowohl im SIMPLE als auch im FULL Mode
das hat alles leider nichts geholfen
ALTER DATABASE Session
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (Session_log, 1)
GO
ALTER DATABASE Session
SET RECOVERY FULL
dbcc shrinkfile (session_log,200)
SELECT name FROM sys.master_files WHERE type_desc = 'LOG'
BACKUP LOG Session TO DISK = 'd:\backup\session.TRN'
GO
Processed 1 pages for database 'Session', file 'session_log' on file 6.
The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader Agent or capture job is running or use sp_repldone to mark transactions as distributed or captured.
BACKUP LOG successfully processed 1 pages in 0.005 seconds (1.269 MB/sec).
Completion time: 2022-09-28T07:44:53.4646056+02:00
BACKUP LOG [Session] TO DISK='d:\Backup\Session_Log_.trn' WITH NO_CHECKSUM, CONTINUE_AFTER_ERROR
DBCC SHRINKFILE (Session_log, EMPTYFILE);
DbId
FileId
CurrentSize
MinimumSize
UsedPages
EstimatedPages
33
2
181248
1024
181248
1024
kann ich das so ausführen?
EXEC sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset
= 1
Chris
