Input Parameters: - The directory where the database backups are located - The directory where the data files (i.e. The characters preceeding the '_db_' text determines - the name. For example Insurance_db_200305212302.BAK will be restored to - a database named Insurance. The database - will be restored to a database name that is based on the database backup - file name.
Any database backup that matches the form %_db_% will be restored to - the file locations specified in the RestoreTo.
This script reads all - database backups that are found in the parameter. sysobjects where id = object_id ( N '.' ) and OBJECTPROPERTY ( id, N 'IsProcedure' ) = 1 ) drop procedure. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO if exists ( select * from dbo.