![]() ![]() Valid values are minutes, hours, days, weeks, months and copies. ![]() Valid values are 1 and 0 with 1 = TRUE and 0 = additional verify options as documented in BOL for the VERIFY WITH unit of measure for the parameter. Sub folders will be created for each whether to verify the backup file. REORG - Reorganize all additional backup options as documented in BOL for the BACKUP WITH base folder to write the backups to.Valid values are a single database name, ALL_USER which will process all user databases and ALL_SYSTEM which will process all system type of maintenance operation to be performed. The following table describes the available parameters in this stored target database for the maintenance operation. This will install expressmaint stored procedure provides the following features: You can install the stored procedure by executing the sql_express_maintanance.sql file on your SQL Server (on the Master DB, system databases/master) with a user that has sysadmin rights. Installing the stored procedure for maintenance ![]() In this document we explain how to use these two parts to create you database backup solution. We recommend Windows Task Scheduler to run the maintenance tasks Verba provides a stored procedure, called expressmaint (comes installed with the product) There are two parts of the backup solutions for Express Edition: SQL Server 2005/2008 Express Edition does not contain maintenance plans and SQL Server Agent service. Database backup with SQL Server Express Edition ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |