/ Published in: SQL
Pasar una BD de una pc a otra
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
RESTORE FILELISTONLY FROM DISK = 'C:\bdEuroidiomas.BAK' IF EXISTS(SELECT NAME FROM SYSDATABASES WHERE NAME = 'bdEuroidiomas') BEGIN DROP DATABASE bdEuroidiomas; END GO RESTORE DATABASE BDEuroidiomas FROM DISK = 'C:\bdEuroidiomas.bak' WITH RECOVERY, MOVE 'euroidiomas_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\bdEuroidiomas.mdf', MOVE 'euroidiomas_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\bdEuroidiomas_log.ldf' GO