Is there an easier way of restoring to the latest backup file via script?

Question

Currently I have to specify FILE= (which backup set) when I write a restore script

USE master

RESTORE database [db] FROM DISK=N'filepath' WITH FILE=1(sometimes can be 2 or 3 ,depending on the latest backup set)

Is there an easier way to get file no without creating an inserting the table as follows?

http://stackoverflow.com/questions/2543920/restore-latest-backup-from-bak-file-with-script

Answer 1

Hello,

The easy solution is to not append backups. Personally I'm not a fan of appending backups as a corruption of that file pretty much makes all others useless. It also causes the file to grow and grow, rather than be part of normal growth control processes.

AFAIK there is not an easier way to get the file number.

-Sean

---

Sean Gallardy | Blog | Twitter

Answer 2

FWIW, I agree with Sean.

---

Tibor Karaszi, SQL Server MVP | web | blog