| |
 |
Say
you've decided to run RESTORE
VERIFYONLY on all
SQL Server 2005 backup files that you copy to a file server, and
you did run the backups using the CHECKSUM option, right?
Otherwise, please read this article. However, the departmental
budget did not provide for the purchase and maintenance costs of
another SQL Server 2005 license. What now?
Well, enter SQL Server 2005 Express Edition (Express). That's the
free edition of SQL Server 2005, that's usually associated with
under-4 GB databases. A little known fact is that Express is able
to work with files larger than 4 GB when running the RESTORE
VERIFYONLY command.
That's right, you can install Express on your file server where all
your backup files are stored, and happily verify all your backup
files to ensure that they are valid. Did I mention that Express is
free?
Obviously, you'll need to write some code to trigger the
verification, logging and notification of errors etc (ok, it's not
entirely free in that sense).
At the time of writing, you can download Express from this
link.
Discuss or comment on this article on our Facebook group.
Document history
| 6/27/2008 | Initial release. |
|
