ssandu:Este valabil si ptr SQL Server 2008 (nu mai are NO_LOG sau TRUNCATE_ONLY) ?
Ce recomanzi ?
DBCC SHRINKFILE nu merge decat daca recovery model e SIMPLE.
Ai incercat ceea ce se recomanda
aici ?
Backup and restore | BACKUP LOG WITH NO_LOG | None.
The transaction log is automatically truncated when the database is
using the simple recovery model. If you must remove the log backup
chain from a database, switch to the simple recovery model. |
| Backup and restore | BACKUP LOG WITH TRUNCATE_ONLY | None.
The transaction log is automatically truncated when the database is
using the simple recovery model. If you must remove the log backup
chain from a database, switch to the simple recovery model. |