Restore DataBase, SQL server 2008 R2 from Query

0

I want to do this by consulting according to the steps I was wondering, what would the Scrip query be for this SQL Server 2008 R2? eye without having previously the Mdf or the ldf on the hard disk before the restoration I mean I want the .bak to create the query.

    
asked by Juan Carlos Villamizar Alvarez 01.08.2018 в 01:44
source

1 answer

0

I think you need something like this:

RESTORE DATABASE DB_Clients
FROM DISK = 'C:\DB_Clients.bak'
WITH REPLACE
WITH MOVE 'YourMDFLogicalName' TO '<MDF file path>',
MOVE 'YourLDFLogicalName' TO '<LDF file path>'
    
answered by 01.08.2018 в 01:49