-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Pandurang_Nayak
Message 6 in Discussion
to backup log file:
To create a transaction log backup
Execute the BACKUP LOG statement to back up the transaction log,
specifying:
The name of the database to which the transaction log to back up
belongs.
The backup device where the transaction log backup will be written.
Optionally, specify:
The INIT clause to overwrite the backup media, and write the backup as
the first file on the backup media. If no existing media header exists, one
is automatically written.
The SKIP and INIT clauses to overwrite the backup media even if there
are either backups on the backup media that have not yet expired, or the
media name does not match the name on the backup media.
The FORMAT clause, when using media for the first time, to completely
initialize the backup media and rewrite any existing media header.
The INIT clause is not required if the FORMAT clause is
specified.
Important Use extreme caution when using the FORMAT
or INIT clauses of the BACKUP statement as this will destroy any backups
previously stored on the backup media.
Examples
This example creates a transaction log backup for the MyNwind database
to the previously created named backup device, MyNwind_log1:BACKUP LOG MyNwind
TO MyNwind_log1
GO
To clear the log file:dump tran MyNwind with no_log
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
