USE master
GO
BACKUP DATABASE database_1
TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database_1' WITH init
RESTORE FILELISTONLY
FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database_1'
RESTORE DATABASE database_2
FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database_1'
WITH MOVE 'database_1' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database_2.mdf',
MOVE 'database_1_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database_2.ldf'
GO
Can anybody see what's wrong? OR mayby give me an option how to create an exact copy of an existing database (on the same server). Thanks in advance!
Regards
Jenny