Full Backup DB is too large of DB & TL

Hi everyone, im newie in SQL administrator, well... this is the case:
STS_SupportoDSIES_1.mdf 5.056KB
STS_SupportoDSIES_1_log.LDF 1536KB
STS_SuportDSIES_1_LOG.BAK 18KB (backup of Transaction
Log)
STS_Supportodsies_1.BAK 9.273.877 KB (this is a
Full Backup)
1) I truncate Transaction LOG
2) Shrink DB
3) Execute a Transaction Log backup.
4) Execute a Full backup of DB
the problem is a BIG full backup, what is worng..?
Thaks.!
Have you ran FULL BACKUP database WITH INIT option?
<er.fuser@.gmail.com> wrote in message
news:1173788021.710651.177500@.j27g2000cwj.googlegr oups.com...
> Hi everyone, im newie in SQL administrator, well... this is the case:
> STS_SupportoDSIES_1.mdf 5.056KB
> STS_SupportoDSIES_1_log.LDF 1536KB
> STS_SuportDSIES_1_LOG.BAK 18KB (backup of Transaction
> Log)
> STS_Supportodsies_1.BAK 9.273.877 KB (this is a
> Full Backup)
> 1) I truncate Transaction LOG
> 2) Shrink DB
> 3) Execute a Transaction Log backup.
> 4) Execute a Full backup of DB
> the problem is a BIG full backup, what is worng..?
> Thaks.!
>
|||Hello,
By default the backup files gets appended to the file and will store
multiple backup copies in same backup file. You could see this
using BACKUP HEADERONLY command. If you do not want multiple copies use INIT
option to overwrite the backup file.
Thanks
Hari
<er.fuser@.gmail.com> wrote in message
news:1173788021.710651.177500@.j27g2000cwj.googlegr oups.com...
> Hi everyone, im newie in SQL administrator, well... this is the case:
> STS_SupportoDSIES_1.mdf 5.056KB
> STS_SupportoDSIES_1_log.LDF 1536KB
> STS_SuportDSIES_1_LOG.BAK 18KB (backup of Transaction
> Log)
> STS_Supportodsies_1.BAK 9.273.877 KB (this is a
> Full Backup)
> 1) I truncate Transaction LOG
> 2) Shrink DB
> 3) Execute a Transaction Log backup.
> 4) Execute a Full backup of DB
> the problem is a BIG full backup, what is worng..?
> Thaks.!
>
|||Yes i do.!!!
this is the command line:
BACKUP DATABASE [STS_SupportoDSIES_1] TO [STS_SuportDSIES_1] WITH
INIT , NOUNLOAD , NAME = N'STS_SupportoDSIES_1 backup', NOSKIP ,
STATS = 10, NOFORMAT
Uri Dimant ha scritto:
[vbcol=seagreen]
> Have you ran FULL BACKUP database WITH INIT option?
>
> <er.fuser@.gmail.com> wrote in message
> news:1173788021.710651.177500@.j27g2000cwj.googlegr oups.com...