I'm using MS SQL Server 6.5. I have to perform daily back/restore on one of my database.

Currnetly, I have manually restore database from device with the following parameters.

Destination Database: bic_db
Devices and files: diskbackup

The question is: instead of having to perform all the above, is there any T-SQL statement to do restoration?

Thankx for your help.