<div>
Take a look at the stored proc sp_delete_backuphistory &nbsp;even though you delete the actual backup files, the history is maintained in MSDB.<br />
<br />
Brett
</div>


Take a look at the stored proc sp_delete_backuphistory  even though you delete the actual backup files, the history is maintained in MSDB.

Brett

<div>
<div class="content wysiwyg-content">
I am using SQL Server 2000. &nbsp;I have been doing a full daily backup for over a year now. &nbsp;I have the backup job set to delete any old backup files over 7 days old. &nbsp;When I open the restore database and pick the database I want fo restore from it can take 5 minutes before I can even select the correct date. &nbsp;Even though the backup files no longer exist the drop down for dates goes all the way back. Is there a way to fix this?
</div>
</div>


I am using SQL Server 2000.  I have been doing a full daily backup for over a year now.  I have the backup job set to delete any old backup files over 7 days old.  When I open the restore database and pick the database I want fo restore from it can take 5 minutes before I can even select the correct date.  Even though the backup files no longer exist the drop down for dates goes all the way back. Is there a way to fix this?

Restore in Enterprise Manager slow to initialize due to excessive old backups.

A font is a particular size, weight and style of a typeface. Each font is a matched set of type, one piece (called a "sort") for each glyph, and a typeface consists of a range of fonts that share an overall design. With the advent of digital typography, font is frequently synonymous with typeface, although the two terms do not necessarily mean the same thing. In particular, the use of "vector" or "outline" fonts means that different sizes of a typeface can be dynamically generated from one design. Each style may still be in a separate "font file" -- for instance, the typeface "Futura" may include the fonts "Futura roman", "Futura italic", "Futura bold" and "Futura extended" —- but the term "font" might be applied either to one of these alone or to the whole typeface.

Fonts Typography

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.