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

• Microsoft SQL Server version 7.0

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'}).

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          : 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbinfo 

Last Reviewed: April 21, 1999