Restore database in sql server

Question

I have some sql server's backup file(format .bck). In my case, I do not know log file name. So I can't use with move in restore command. Is there anyway to restore database without move? If yes, please guide me.

I want to use like below one.

restore database testdb from disk = 'folderpath\aatest.bak'

Remus Rusanu · Accepted Answer · 2013-05-21 11:51:18Z

3

You sure can know the log file name and use WITH MOVE. Use RESTORE FILELISTONLY to retrieve the list of database files (including log) from the backup first.

answered May 21, 2013 at 11:51

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user2053420 Over a year ago

One of my files has data,log file's name are same, only file extension are different. for example data file = 'C:\user\test\db.ADF' log file = 'C:\user\test\db.ALF'

user2053420 Over a year ago

So I can't use move, that why I said do not want with move part.

Remus Rusanu Over a year ago

rename to change extension is a MOVE

user2053420 Over a year ago

I have tried like following, but noting will happened always throws is not part of database error. 1)RESTORE DATABASE test from disk='test.bak' WITH MOVE 'ADF' TO 'F:\test.adf', move 'ALF' To 'F:\test.alf'; 2)RESTORE DATABASE test from disk='test.bak' WITH MOVE 'test.ADF' TO 'F:\test.adf', move 'test.ALF' To 'F:\test.alf';

Collectives™ on Stack Overflow

Restore database in sql server

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related