localdb - Cannot restore database with .mdf extension in sql server -
i have back-up database localdb
server .mdf
file:
c:\thesis - source code\sis-jen\sis\app_data\sis_db.mdf
and backed-up extension of .bak
:
c:\thesis - source code\sis-jen\sis\app_data\sis_db.mdf.bak
now, want restore back-up file new server(my pc/server), cannot restore using .bak
file:
c:\thesis - source code\sis-jen\sis\app_data\sis_db.mdf.bak
i've got error:
restore of database 'c:\thesis-source code\sis-jen\sis\app_data\sis.db.mdf' failed
check restore
statement -
use [master] go restore database [sis_db] disk = n'd:\sis_db.bak' file = 1, move n'sis_db' n'd:\sis_db.mdf', move n'sis_db_log' n'd:\sis_db_log.ldf', nounload
Comments
Post a Comment