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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Nov 30, 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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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