Microsoft KB Archive/196905

= INF: Backup with INIT or FORMAT Is Documented in Error Log =

Article ID: 196905

Article Last Modified on 4/23/1999

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q196905



SUMMARY
It may appear that SQL Server backup no longer documents whether a backup device has been initialized in the error log. Actually, this is documented, but not in the same format as in SQL Server 6.5.

The FILE= attribute in the error log provides the necessary information. For example, if the error log says FILE = 1, either an INIT or a FORMAT command was issued.


 * 'FILE = 1' means the backup device was initialized.
 * 'FILE = >1' means the backup device was NOT initialized.



MORE INFORMATION
The following are two examples of what the SQL Server 7.0 messages look like in the error log:

1998-11-17 18:17:47.98 backup Database backed up with following

information: Database: bck_db, creation date and time:

11/17/98(18:09:42), pages dumped: 107, first LSN: 4:32:1, last LSN:

4:34:1, sort order: 52, striped: 0, number of dump devices: 1, device

information: (FILE=1, TYPE=DISK: {'c:\temp\fb1.bck'}).

1998-11-17 18:33:54.28 backup Database backed up with following

information: Database: bck_db, creation date and time:

11/17/98(18:09:42), pages dumped: 106, first LSN: 4:42:1, last LSN:

4:44:1, sort order: 52, striped: 0, number of dump devices: 1, device

information: (FILE=2, TYPE=DISK: {'c:\temp\doit.bck'}).

In SQL Server 6.5, the messages looked like the following:

98/12/07 10:54:00.30 backup DATABASE dumped with following info:

Database Name:pubs, Creation Date and Time:Dec 7, 98(10:53), Pages

dumped:161, Current Sequence:36075 11572328, Sort Order:52, Striped:NO,

Number of Dump Devices:1, device info:(VOLID=SQL0001

NAME=D:\temp\65pubs.dat TYPE=DISK FILE=1)

98/12/07 10:54:13.34 backup DATABASE dumped with following info:

Database Name:pubs, Creation Date and Time:Dec 7, 98(10:54), Pages

dumped:161, Current Sequence:36075 11572328, Sort Order:52, Striped:NO,

Number of Dump Devices:1, device info:(VOLID=SQL0001

NAME=D:\temp\65pubs.dat TYPE=DISK FILE=2)

Additional query words: restore load back up dump errorlog

Keywords: kbinfo KB196905

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.