Set = ' ReplaceRestoreDirectoryHere ' - such as ' c :\ temp \ ' Set the path to the directory containing the database backup Set the name of the database to restore
#شرح backup exec 2010 full
WHILE FETCH_STATUS = 0 BEGIN declare DBFileName varchar ( 256 ) set DBFileName = DbName + '_' + replace ( convert ( varchar, getdate (), 112 ), '-', '.' ) + '.bak' -REMEMBER TO PUT HERE THE TRAILING \ FOR THE DIRECTORY !!! exec ( 'BACKUP DATABASE TO DISK = N''D:\DATA\BACKUPS\' + ''' WITH NOFORMAT, INIT, NAME = N ''' + ' - Full Database Backup '', SKIP, NOREWIND, NOUNLOAD, STATS = 100 ')įETCH NEXT FROM DATABASES_CURSOR INTO DATABASES_CURSOR database_idįETCH NEXT FROM DATABASES_CURSOR INTO DBName database_id )) = 1 - Not master, tempdb or model -and db_name(s_mf.database_id) not in ('Master','tempdb','model') group by s_mf. state = 0 - Only look at databases to which we have access and has_dbaccess ( db_name ( s_mf. cmd = END -=BackUpAllMyDatabases.sql start DECLARE DBName varchar ( 255 ) DECLARE DATABASES_Fetch intĭECLARE DATABASES_CURSOR CURSOR FOR selectĭATABASE_NAME = db_name ( s_mf.
Sqlcmd - S localhost - e - i "BackUpAllMyDatabases.sql" - o Result_Of_BackUpAllMyDatabases. :: RUN THE SQL SCRIPT VIA THE COMMAND LINE WITH LOGGING :: COMMAND LINE BATCH SCRIPT FOR TAKING BACKUP OF ALL DATABASES '', NOUNLOAD, REPLACE, STATS = exec query ) Select = physical_name from ' + NewDB + '.sys.database_files where type_desc = ''LOG''
Select = physical_name from ' + NewDB + '.sys.database_files where type_desc = ''ROWS'' Select = name from ' + OldDB + '.dbo.sysfiles where filename like ''%.mdf%'' Select = name from ' + OldDB + '.dbo.sysfiles where filename like ''%.ldf%'' */ SET NOCOUNT ON Select query = 'Create Database ' + NewDB Select = '\\dbserver\C$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\pubs.bak'