Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 1, 2000

SQL Server Based Backup Application v2

By Maxim Smirnov

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM