sqlpro for mssql create table from table

,Physical_FileName varchar ( 1000 ) ) if is null begin select dbid, name

This script works if the server name is 14 char long and if it exists a share called like 'Backups_XXXXX' - where XXXXX is last 5 characters of the servername - Usage : - Configure the data, log and index paths - Configure the list of DB to restore - Configure the backup date - Configure the backup instance name - Run this script on the source server - Run the output script on the target server - SET nocount on if exists ( select * from sysobjects where name = 'SYS_getDatabaseFilenames' and xtype = 'p' ) begin drop procedure SYS_getDatabaseFilenamesĮnd GO Create procedure varchar ( 255 ) = null -dbname as declare int -Counter declare varchar ( 700 ) -build dynamicaly if exists ( select * from sysobjects where name = 'SYS_DatabasesFiles' and xtype = 'U' ) BEGIN drop table SYS_DatabasesFiles Finally it will remove the stored procedure. Then based on the configured value for the target server and the list of DB to restore - it will generate the restore script.

Generate DB restore script using SQL Backup - Author : Jerome Duquène - Last review : 9 - Description : - As first step, this script will create the procedure SYS_getDatabaseFileNames.

Sqlpro for mssql create table from table