dcsimg

SQL Server Based Backup Application v2

November 30, 2000

Attached script is an addition to the original version of the SQL Server backup application. (See previous article at http://www.swynk.com/friends/smirnov/backupsapp.asp)

Here is the list of the updated implementing with the script:

  • New procedure sp_DB_CheckCatalog was added to check consistency of the database system catalog by running DBCC CHECKCATALOG for each database. Procedure will generate records in the tbl_Activity_Log showing the status of the catalog check (COMPLETE / FAIL).
  • Procedure sp_DB_Reindex has been fixed to avoid error messaged from the improper SQL statement to check the existence of the indexes defined for the table
  • Procedure sp_Backup_Data has been change to call procedure sp_DB_CheckCatalog. Please remember to change the path stored in the variable @backup_device_path ("C:\MSSQL7\BACKUP\") to the one you use to store your backups.
I would like to thank everyone for your interest and suggestions. Download Scripts







The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers