Nueva BD copia de una ya creada

[mamcx]

Con Sql Server es maso asi:

https://stackoverflow.com/questions/...se-for-testing

Código SQL [-]
BACKUP DATABASE Database_Production TO DISK ='H:\test\Database_Production.bark';

RESTORE DATABASE Database_Testing 
    FROM DISK='H:\test\Database_Production.bark' 
    WITH 
        MOVE 'Database_Production_Data' TO 'H:\test\Database_Testing_Data.mdf',
        MOVE 'Database_Production_log' to  'H:\test\Database_Testing_Data.ldf';