Restore database in sql server -
i have sql server's backup file(format .bck). in case, not know log file name. can't use with move
in restore command. there anyway restore database without move? if yes, please guide me.
i want use below one.
restore database testdb disk = 'folderpath\aatest.bak'
you sure can know log file name , use with move
. use restore filelistonly
retrieve list of database files (including log) backup first.
Comments
Post a Comment