o tai ne paprasčiau full backup'ą pasidaryt?


"filia" <filianereiksh@barsukas.com> wrote in message news:mn.64357db2a0b3aaca.73604@barsukas.com...
> Pas tave tikriausia log failas didelis.
> Cia kaip ji sumazinti:
> 
> USE dbname;
> GO
> -- Truncate the log by changing the database recovery model to SIMPLE.
> ALTER DATABASE dbname
> SET RECOVERY SIMPLE;
> GO
> -- Shrink the truncated log file to 1 MB.
> DBCC SHRINKFILE (2, 1);  -- here 2 is the file ID for trasaction log
> GO
> -- Reset the database recovery model.
> ALTER DATABASE dbname
> SET RECOVERY FULL;
> GO
> 
>