how to restore .Dat extention to mssql 2008....

Apr 8 2018 5:18 AM

RESTORE DATABASE cbstest
FROM DISK = 'C:\JLV_CON_20180131_IMP.DAT'
WITH RECOVERY,
MOVE 'cbstest' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\cbstest.mdf',
MOVE 'cbstest_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\cbstest.ldf'

this JLV_CON_20180131_IMP.DAT genrate from oracle db

how to restore to mssql2008

Answers (2)

cursor in Sql Server