Probably far too late for you, but this is the script I wrote a while ago that I use.
DECLARE @SQL VarChar(8000)
SET @SQL = 'BACKUP DATABASE [' + DB_Name() + '] TO
DISK = N''\\10.129.11.210\sqldumps\xxx\' + DB_Name() + '_Full_File1_' + REPLACE(CAST(GetDate() AS VarChar(11)), ' ', '_') + '.bak'',
DISK = N''\\10.129.11.210\sqldumps\xxx\' + DB_Name() + '_Full_File2_' + REPLACE(CAST(GetDate() AS VarChar(11)), ' ', '_') + '.bak''
WITH INIT , NOUNLOAD , NAME = N''' + DB_NAME() + ' Backup'', NOSKIP , STATS = 10, NOFORMAT
RESTORE DATABASE [' + DB_NAME() + '] FROM
DISK = N''\\10.129.11.210\sqldumps\xxx\' + DB_Name() + '_Full_File1_' + REPLACE(CAST(GetDate() AS VarChar(11)), ' ', '_') + '.bak'',
DISK = N''\\10.129.11.210\sqldumps\xxx\' + DB_Name() + '_Full_File2_' + REPLACE(CAST(GetDate() AS VarChar(11)), ' ', '_') + '.bak''
WITH FILE = 1,
'
SELECT @SQL = @SQL + 'MOVE N''' + RTrim(name) + ''' TO N''' + Case When FileID = 1 Then 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\' Else
Case When GroupID = 0 Then 'E:\TLogs\' Else 'K:\DATA\' End End + RTrim(name) + Case When GroupID = 0 Then '.LDF' Else '.MDF' End + ''', -- ' +
Cast(Convert(Decimal(12,2),Round(( ( ( Size * 64.0 ) / 1024 ) / 8 ),2)) AS VarChar(10)) + 'Mb
'
FROM sysFiles
SET @SQL = @SQL + 'NOUNLOAD, STATS = 10'
PRINT @SQL |