quote:

---

Originally posted by Chad Saar

I guess I am confused. I wanted to restore a database, when I run this it says The command(s) completed successfully. But the database is not there and it completes way to quick for a restore. I need to restore a database from a backup for the first time in a single query because I will not be there to do it, it will be automated.

---

quote:

---

Originally posted by Chad Saar

I guess I am confused. I wanted to restore a database, when I run this it says The command(s) completed successfully. But the database is not there and it completes way to quick for a restore. I need to restore a database from a backup for the first time in a single query because I will not be there to do it, it will be automated.

---

CREATE TABLE ##Restore (LogicalName nvarchar(128), PhysicalName nvarchar(260), Type char(1), FileGroupName nvarchar(128), SizeB numeric(20, 0), MaxSizeB numeric(20, 0))

INSERT INTO ##Restore
EXEC('RESTORE FILELISTONLY FROM DISK = ''C:\MSSQL\BACKUP\Toolbox\Toolbox_20060713141727.BAK''')

DECLARE @LogicalNameData nvarchar(128), @LogicalNameLog nvarchar(128)

SELECT @LogicalNameData = LogicalName
FROM ##Restore
WHERE Type = 'D'

SELECT @LogicalNameLog = LogicalName
FROM ##Restore
WHERE Type = 'L'

DECLARE @SQL nvarchar(4000)

SET @SQL = 'RESTORE DATABASE SomeDatabaseName FROM DISK = ''C:\MSSQL\BACKUP\Toolbox\Toolbox_20060713141727.BAK'' WITH MOVE '''
SET @SQL = @SQL + @LogicalNameData + ''' TO ''C:\MSSQL\DATA\SomeDatabaseName_Data.MDF'', MOVE ''' + @LogicalNameLog + ''' TO '
SET @SQL = @SQL + '''C:\MSSQL\DATA\SomeDatabaseName_Log.LDF'''

--PRINT @SQL

EXEC(@SQL)

DROP TABLE ##Restore