Very Computer

I am still confused about the backup scenario with the INIT and NOINIT
option. Does it only apply to TAPE DEVICE BACKUP not DISK DEVICE?

What's the different between INIT and NOINIT option? I tried both. The
listing of all my transactional log backup displayed with INIT as well
as NOINIT options under the Backup/Restore tab.

And if I am relying on the transactional backup to do the point in time
recovery, does that mean I ought to pick the NOINIT option if it
requires for the DISK DEVICE BACKUP??? But the file can grow really big!
How can I clean it up nightly after the typical full backup?

Thanks in advance.

Sent via Deja.com http://www.deja.com/
Before you buy.

Inline...

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

It applies to both tape and disk. The file acts just as a tape. You can have several
backups to the same file, each adressed with the FILE option.

Quote:

> What's the different between INIT and NOINIT option?

INIT overwrites.

Quote:> I tried both. The
> listing of all my transactional log backup displayed with INIT as well
> as NOINIT options under the Backup/Restore tab.

You were looking at the backup history. That dialog does not verify that the backup
that were done actually physically exists.

Quote:

> And if I am relying on the transactional backup to do the point in time
> recovery, does that mean I ought to pick the NOINIT option if it
> requires for the DISK DEVICE BACKUP??? But the file can grow really big!
> How can I clean it up nightly after the typical full backup?

You have to have  a script/schedule/etc which does INIT at the frequency that you
desire...

Quote:

> Thanks in advance.

> Sent via Deja.com http://www.deja.com/
> Before you buy.