ALTER SERVICE MASTER KEY FORCE REGENERATE

USE [master]
RESTORE DATABASE [databasename] 
	FROM DISK = N'F:\sql_backup\databasename.bak' 
	WITH  MOVE N'dataFileName' TO N'D:\sql_data\DataFileName.mdf',
		  MOVE N'logFileName_log' TO N'F:\sql_log\logFileName_log.LDF',
		  NORECOVERY
GO

RESTORE DATABASE [databasename]
	FROM DISK = N'F:\sql_backup\databasename.bak'
GO

SET NOCOUNT ON;  

DECLARE @dbID int,
		@dbName VARCHAR(100),
		@dataFileName VARCHAR(100),
		@dataFilePhysicalfileName VARCHAR(100),
		@logFileName VARCHAR(100),
		@logFilePhysicalfileName VARCHAR(100)
  
DECLARE dbCur CURSOR FOR
SELECT database_id, name FROM sys.databases where database_id > 4
print 'USE [master]'  
OPEN dbCur
FETCH NEXT FROM dbCur INTO @dbID, @dbName  
WHILE @@FETCH_STATUS = 0  
BEGIN  
    SELECT @dataFileName = name, @dataFilePhysicalfileName = physical_name from sys.master_files where database_id = @dbID and type = 0
	SELECT @logFileName = name, @logFilePhysicalfileName = physical_name from sys.master_files where database_id = @dbID and type = 1
    
	print 'RESTORE DATABASE [' + @dbName +  ']'
	print '	FROM DISK = N''F:\sql_backup\' + @dbName + '.bak'''
	print '	WITH  MOVE N''' + @dataFileName + ''' TO N'''+ @dataFilePhysicalfileName + ''','
	print '	      MOVE N''' + @logFileName + ''' TO N'''+ @logFilePhysicalfileName + ''','
	print '		  NORECOVERY'
	print 'GO'
	print 'RESTORE DATABASE [' + @dbName +  ']'
	print '	FROM DISK = N''F:\sql_backup\diff\' + @dbName + '.bak'''
	print 'GO'

	FETCH NEXT FROM dbCur INTO @dbID, @dbName  
END   
CLOSE dbCur;  
DEALLOCATE dbCur;

SELECT '
RESTORE ' + d.name + '
RESTORE DATABASE [' + d.name +  ']
FROM DISK = N''F:\sql_backup\' + d.name + '.bak''
WITH MOVE N''' + (SELECT top 1 name from sys.master_files as m where m.database_id = d.database_id and m.type = 0) + ''' TO N'''+ (SELECT top 1 physical_name from sys.master_files as m where m.database_id = d.database_id and m.type = 0) + ''',
	MOVE N''' + (SELECT top 1 name from sys.master_files as m where m.database_id = d.database_id and m.type = 1)  + ''' TO N'''+ (SELECT top 1 physical_name from sys.master_files as m where m.database_id = d.database_id and m.type = 1) + ''',
	NORECOVERY
GO
RESTORE DATABASE [' + d.name +  ']
FROM DISK = N''F:\sql_backup\diff\' + d.name + '.bak''
GO
'
FROM sys.databases as d where d.database_id > 4