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