--- Se hace un Backup de la base
BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
--- Se verfica el NOMBRE del backup
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
--- Se hace el RESTORE en la base TESTDB
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'