Folgend ein Sript um alle Datenbanken auf einem SQL Server zu restoren:

SET NOCOUNT ON;
DECLARE @DatabaseName NVARCHAR(128)
DECLARE DB_Cursor CURSOR FOR
Select Name as DatabaseName from sys.databases
order by DatabaseName
OPEN DB_Cursor;
FETCH NEXT FROM DB_Cursor INTO @DatabaseName;
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT '--============================================='
PRINT '--RESTORE ZIELSERVER ' + @DatabaseName
PRINT '--============================================='
PRINT 'USE [master]'
PRINT 'GO'
PRINT 'RESTORE DATABASE [' + @DatabaseName + ']' 
PRINT 'FROM  DISK = N''E:\' + @DatabaseName + '.bak'''
PRINT 'WITH  FILE = 1,  '
PRINT 'MOVE N''' + @DatabaseName + ''' TO N''E:\' + @DatabaseName + '.mdf'',  '
PRINT 'MOVE N''' + @DatabaseName + '_log'' TO N''F:\' + @DatabaseName + '_log.ldf'', ' 
PRINT 'NOUNLOAD, ' 
PRINT 'STATS = 5'
PRINT 'GO'
PRINT ''
FETCH NEXT FROM DB_Cursor INTO @DatabaseName;
END;
CLOSE DB_CURSOR;
DEALLOCATE DB_CURSOR;
GO